Help needed on Reconcilliation Query

[Guest]

Hi I have two tables: CHARGES (2000 records), PAYMENTS (1650 records)

I want to run a query against these two tables which will give me only the
350 records which are the exceptions from the CHARGES table. How can I build
this query?

Thanks for your help.

 

[Gary Walter]

Hi I have two tables: CHARGES (2000 records), PAYMENTS (1650 records)

I want to run a query against these two tables which will give me only the
350 records which are the exceptions from the CHARGES table. How can I
build
this query?

How do these tables relate (match) to each other?

As a guess, they might each contain a field
called BillID. If so, the usual "unmatched" query

(for which there is a wizard that can help you
if this does not help)

starts in Query Designer with the 2 tables
joined on BillID.

Right-mouse click on the join line,
choose "Properties,"
then choose option to show all CHARGES
and only matching PAYMENTS.

Bring all the pertinent fields from CHARGES
down to the grid.

Then bring PAYMENTS.BillID down to
a column in the grid. In the "Criteria" row
for that column, type

IS NULL