Error Report

[Cherish2007]

Hello, I have two tables, the main one which shows account numbers and a second table which shows a date and a sales transaction by account number. I need to identify which account number from the Sales table is not included in the main table. Once I identify it, I can add it to the main table. Does anyone know the easy way of doing it? thank you

 

[PHV]

Simply follow the unmatched query wizard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Cherish2007]

Sorry, where do I find unmatched query wizard???

 

[PHV]

Click the New button in the Queries window.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Cherish2007]

Found it! Thanks