Returning null records?

[jrscse]

Hello everyone.

I have just joined the forum and spent the last day or so looking around for an answer that I wasn't able to find.

I have been asked by my employer to capture details of who has signed our confidentiality policy. I have made a very simple database which only has three tables, EMPLOYEE, POLICY and VERSION.

EMPLOYEE has three fields, NAME, NUMBER and BRANCH. POLICY has three fields, NUMBER, DATE and VERSION. VERSION has two fields, VERSION NUMBER and DATE. I won't worry about the VERSION table any further in this post as it doesn't figure in the problem query.

Primary key for EMPLOYEE is NUMBER. Compound key for POLICY is NUMBER and DATE (ie. the employee can sign the policy more than once and we want to record when this was, and whether the policy version changed).

I have an Access "type 3" join defined in table relationships from EMPLOYEE.NUMBER to POLICY.NUMBER.

I am trying to write a query that returns the employees that haven't signed the policy. I have no problem returning the employees that have (ie. employees whose numbers match the numbers in the POLICY.NUMBER field), but it is the EMPLOYEE.NUMBER entries that are not present in POLICY.NUMBER that are causing me grief.

I have tried using the expression builder in the query builder window (it gave me <>[tblPolicy]![Number]) which doesn't return any records (I have over 490 in the database and should be getting back at least 50 or so).

Sorry if this question is too basic.

Can anyone offer me any advice here?

Thanks in anticipation.

John

 

[EMP]

Try using the Find Unmatched Query Wizard. (Click on the New button in the Query tab."

^

 

[jrscse]

Thanks - your suggestion worked.

I was working on the database in Access 2003 at work then opened it in Access 2007 (after I got home) and didn't have any trouble locating that "Find Unmatched Query Wizard" and applying it, though I couldn't remember seeing it in Access 2003.

Thanks again for such a quick reply.

John