Help Query.

[Guest]

Hi,

I have 2 tables, one it has customers who are past due and another table
that has customers who have paid and not past due after a certain period.

My objective is to find the customers who hasn't paid yet. I did a query,
joined by account #, this query will return customers who has paid after they
were past due. But I am looking for account IDs of customers who are still
past due. Anyway to do this? Thansk for the help!

 

[Michel Walsh]

Try the query wizard about finding unmatched rows. It seems you need rows
from the first table that are NOT in the second table.


Hoping it may help,
Vanderghast, Access MVP

 

[John W. Vinson]

Hi,

I have 2 tables, one it has customers who are past due and another table
that has customers who have paid and not past due after a certain period.

My objective is to find the customers who hasn't paid yet. I did a query,
joined by account #, this query will return customers who has paid after they
were past due. But I am looking for account IDs of customers who are still
past due. Anyway to do this? Thansk for the help!

A "Frustrated Outer Join" query will do this. Use the Query wizard to create
an Unmatched query; or do it yourself:

Select the Join line in the query. Select Option 2 (or 3) - "Show all records
in the Past Due table and matching records in the Paid table". This query will
show everyone in the past due table, whether they've paid or not.

Select only the Account Number field from the paid table, and put a criterion
on it of

IS NULL

The query will now show all the records in Past Due *except* those which have
records in Paid.

John W. Vinson [MVP]

 

[Guest]

Thanks i think this should work, will try! thank you!!