Use of EXCEPT command in Access

[kviglas]

Hello to everybody,

Is there a similar command in Access for the EXCEPT command in SQL?

I have created two queries. One with the document types that contain all the accounts from the general ledger (Accnt_All) and one that contains the document types for some accounts (Accnt_Some). I want to find the difference between those two queries. I tried the "Find Unmatched" query, that seemed like what I needed, but it didn' t have any result.

Any ideas?

 

[Eckerslike]

Hi,

Create a new query and add both the Accnt_All and Accnt_Some tables to it. Now drag the document type field from the Accnt_all table to the same field in the accnt_some table. Right click on the join between the 2 tables and click on the join properties. Select option 2.

Now select the fields that you want from your Accnt_all table and also the document type field from you accnt_some table. For this field you need to uncheck the show tick box, and in the criteria put Is Null

This will return all the records from Accnt_all where there is no matching document type in Accnt_Some.