Query comparing two other queries?

[MickeyGreen]

I want to compare two queries as follows: Select all the records in query1 where the value in fieldA does NOT also appear in any record in fieldA of query2. Is there an easy way to do this using the query tools or will this require a vba function?

 

[JoeComputer]

Find Unmatched Query Wizard

Have you tried the "Find Unmatched Query Wizard"? Click the "new" button in the query tab to bring up a box to choose it.

 

[MickeyGreen]

That was easy! Thanks.

 

[JoeComputer]

Glad I could help.