Audit Database

N

Natalia

For an audit - I have to compare a query and a table to make sure the total
number of records coincide. If there is a mismatch, someone entered the
wrong characters so the query will not be populated with the selected info.
Is there any way of letting the computer find the discrepancy? Let’s say the
table has 200 records and the query has 195 records. Can the computer find
the records that are not populating the query, but are in the table?

Thank you
 
F

Frank Stone

hi,
yes there is. the computer wont but access will.
on the query tab of the database window, click new query.
select "Find Unmatched Query Wizard".
Follow the Wizard's insturction.

Regards
Frank
-----Original Message-----
For an audit - I have to compare a query and a table to make sure the total
number of records coincide. If there is a mismatch, someone entered the
wrong characters so the query will not be populated with the selected info.
Is there any way of letting the computer find the
Click to expand...
discrepancy? Letâ?Ts say the
 
N

Natalia

Thank you so much for your help – I created the “Find Unmatched†Query –
comparing a table and a query and everything worked out fine. Then I created
another “Find Unmatched†Query comparing another table and query and it was a
mess. The table had 1405 records, the query had 1348 records – Then I ran
the query and the total number of unmatched was 39,826. I noticed that it
duplicated A LOT of records – Why would this happen?

Thank you again
 
Top