Hello Guys,
I have a problem that has to do with Aging Accounts Receivable.
I have three tables with customer account numbers, customer names, customer balances for the years 2003, 2004 and 2005. I need to build a query that will provide the account numbers, names and balances for customers who only appear in the 2004 table and another for those who only appear in 2005. Bear in mind that there are customers whos name appear in 2003, 2004 and also 2005 because they may have outstanding balances on their acconts. Then there are also customers who appear in 2005 only because they were only created then. So basically in my 2005 table, i will have 2003 and 2004 accounts (which may or may not have the similar balance because they might have made a payment) and also new accoutns only created in 2005. The same idea exists for the 2004 table which will have accounts created in 2003 also if they are unsettled. I already built a query by joining ro forming a relationship among the three tables by joining them on account number but i find that when i run a query, i do not get any new accounts that were created in 2005. Any ideas how I can work around this big one? Secondly, I need to create a query that will show me the accounts that had some change in the balance (either an increase or a decrease) for 2005. Any help with this monster of a problem would be greatly appreciated.