How can I compare 2 queries?

[Ben2k]

Hi

I have two queries lets say QueryA and QueryB, both return the same fields but are based on different criteria.

In both queries there is a field called InvoiceNumber

In theory both queries should return the exact same records however there must be a descrepency somewhere in the criteria as there is a difference of 8 records.

Is there anyway I can compare the two queries and return the following

InvoiceNumbers in QueryA which do not appear in QueryB
InvoiceNumbers in QueryB which do not appear in QueryA

I hope theres an easy way to do this otherwise it means printing results of both queries and ticking them off each one, not something I fancy with 2000+ records in each one (especially on a friday!)

Thanks

Ben

 

[gbc123]

Hi,

Have you tried the "find unmatched query wizard"? Very useful. Simply select the 2 tables/queries you wish to check and this will return what is in one but not the other. Do it both ways round.

Good luck.

G.

 

[Ben2k]

Thanks

Where can I find it?

Ben

 

[Norie]

Whne you create a new query Access asks you how you want to do it with the following options

Design View
Simple Query Wizard
Crosstab Query Wizard
Find Duplicates Query Wizard
Find Unmatched Query Wizard