Searching for Missing Data

[Wildcats]

I maintain a database of shipping records which I update weekly. The
database is largely used for simple queries about our shipping activity, and
is not very sophisticated. I keep the data split into seven tables to make
it easier to work with. Each week I import the master file and use a series
of saved Make Table and Append queries to update the tables. This week I
noticed that four of my tables have 292000 records, including the most recent
invoice, while three tables only have 271000 records, indicating that several
weeks are missing from those tables.

Question: How can I construct a query to search my 'Invoices' table and my
'Charges' table to determine which records are present in 'Invoices' [with
full 292k records, including invoice date and order number] but NOT in
'Charges?' The only common data in all tables is the order number. In
simplest terms, if I could query 'Invoices' for all Order numbers and Invoice
dates where the order number is NOT present in 'Charges,' then I would know
which weeks' invoices were not completely uploaded.

I am learning Access as I go, so I appreciate any assistance that the
community can provide!

 

[KARL DEWEY]

The query wizard will create an Unmatched query for you.