Hello,
How do I build the following vlookup in Access?
I have two identical tables (current month table and previous month table) containing the following fields: Account and Current Balance. However, the current month table may contain records that are not part of the previous month table. How do I create a dlookup query that will pull all records from previous month table, including the "N/As" so that I can identify which are the new accounts?
Thank you!
How do I build the following vlookup in Access?
I have two identical tables (current month table and previous month table) containing the following fields: Account and Current Balance. However, the current month table may contain records that are not part of the previous month table. How do I create a dlookup query that will pull all records from previous month table, including the "N/As" so that I can identify which are the new accounts?
Thank you!
