Hi,

I have a spreadsheet I update monthly (currently in Excel, trying to get it into Access). I am trying to create a query in Access that uses the current month's data in one table and compares to last month's data in another table. The columns that are brought in for both the current and last month's tables are: Account Number, Customer Name, and Total Amount Outstanding.

I would like the query to show the current month's data plus any accounts that are now gone, as well as a column displaying the change in the total amount outstanding.

Right now my query is producing rows with the old table data, current table data, and the change, so I am clearly doing it all wrong. I only want one row per account number.

Any help or guidance in how to set this up would be much appreciated.

My end goal is to produce a monthly report that lists new accounts, lost accounts, and changes to current accounts based on the total amount outstanding.

Hi,

I have a spreadsheet I update monthly (currently in Excel, trying to get it into Access). I am trying to create a query in Access that uses the current month's data in one table and compares to last month's data in another table. The columns that are brought in for both the current and last month's tables are: Account Number, Customer Name, and Total Amount Outstanding.

I would like the query to show the current month's data plus any accounts that are now gone, as well as a column displaying the change in the total amount outstanding.

Right now my query is producing rows with the old table data, current table data, and the change, so I am clearly doing it all wrong. I only want one row per account number.

Any help or guidance in how to set this up would be much appreciated.

My end goal is to produce a monthly report that lists new accounts, lost accounts, and changes to current accounts based on the total amount outstanding.

Perhaps you could show us the structure of your tables, and the query you are using.