Looking for a new account

[Cherish2007]

Hi there. I have two tables: one - main one where all the account numbers are (ex: g1234, g1235, g1236, etc) and another table with account numbers and dollar values. Every week this table gets updated with new information. I need to see if there is a new account number in table 2 (the one that gets updated each week), which is not in table 1 (main table). How do i do it? Thank you!

 

[fneily]

Have you looked at the Find Unmatched Query Wizard? This is in the query object section.