Access 97
Posted by admin on 25 Sep 2008 at 10:28 PM
$5.00
Example:
Table: Names Master file
Table: Names with # of calls Monthly
Joe Smith had no calls for Jan so his name is not in the monthly table. I'm looking for a query that will alert me that Joe had no calls.
Can you help?
Thanks
Accepted Answer:
| Answer provided by admin on 25 Sep 2008 at 10:28 PM Try this: build a query with both tables. Make a join between the name fields, then double-click on the join. Choose the option that says "Include ALL records from 'Master' and only those records from 'Monthly' where the joined fields are equal." Then add the name field from your Monthly table and put "Is Null" in the criterial. The join type tells the query to pull in all records from the Master table whether a match is found in the Monthly table or not, so it will match to the Monthly table where it can, and bring in blanks where it can't. The "Is Null" criteria identifies the records where no match was found. |
| Rating: * * * * * Awarded: $5.00 |
Most Recent Questions
Most Recent Answers
Home Page
Login
Register
Information Technology
Software, Hardware, Design
Programming LanguagesDatabase
- Microsoft Access
- MySQL
- Oracle
- PostGreSQL
- SQL Server
- Visual FoxPro
Graphic Design
Operating Platforms
Hardware and Networking
Math and Science
Homework Help
Biology and GeologyMath and Statistics
Chemistry
Physics
Engineering
Are you an information
technology or
math/science expert?
You can earn money by
providing answers to questions
at AnswerArchive.com.
Learn How