get list of what info is missing in a query

S

simon.winder2

I am querying 2 tables from different sources and the link is customer
account number

I want to know how to query what account numbers are missing from one of the
tables
 
J

Jeff Boyce

Simon

Access offers a query wizard to find "unmatched" values (or "not in"
values).

Click the "new query" toolbar button and use that wizard to help.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"[email protected]"
 
Top