Help with 'NOT' query please.

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

Can anyone help with this please.

I have a table of employee data based on first name and surname.

I have a query that produces a filtered list from that table.

I have a second set of records also based on the table of employee data.

I need to produce a list of names based on the query but excluding anyone in
the second list. It is possible for somebody to appear in the second set if
records that does not appear in the query.

I think this can be done by a 'not in' statement but my sql is not up to it.
Can anyone help please.

Ta.
Bill.
 
Bill

If you are not limited to doing this in SQL, you could use the Query Wizard
to help you generate an "Unmatched" query.

By the way, after the wizard is finished, you can then view the SQL
statement Access generates to help with your future SQL efforts.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top