467,081 Members | 989 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,081 developers. It's quick & easy.

Three year Access Query for Accounts Receivable

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.
Mar 7 '07 #1
  • viewed: 2787
Share:
2 Replies
Rabbit
Expert Mod 8TB
I'm only going to take a small bite out of this one for now.
The 3 tables should not be related at all. Rather they should be appended into one large consolidated table for your purposes.
Mar 7 '07 #2
I'm only going to take a small bite out of this one for now.
The 3 tables should not be related at all. Rather they should be appended into one large consolidated table for your purposes.
Ok thank you Rabbit, I will try what you have said and see if I can make some further progress.
Mar 7 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by markspace | last post: by
6 posts views Thread by Steven D.Arnold | last post: by
4 posts views Thread by Wayne B. Stanley | last post: by
3 posts views Thread by jannoergaard@hotmail.com | last post: by
6 posts views Thread by John | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.