Khalil Islamzada
Registered User.
- Local time
- Today, 10:08
- Joined
- Jul 16, 2012
- Messages
- 49
Dear all;
I have an access database which has the following tables;
tbl1) customer info
tbl2) billing info (more than 5 years)
tbl3) payment info (more than 5 years)
In the first table I have info from all my customers, in the 2nd table information about billing amount and date and in the 3rd table information about payment in which bank and how much and when.
Now,
I need to know, customer billed totally, which year, how much paid, how much is the balance?
Please anyone who know do let me know, I really need it.
Thanks
Khalil
I have an access database which has the following tables;
tbl1) customer info
tbl2) billing info (more than 5 years)
tbl3) payment info (more than 5 years)
In the first table I have info from all my customers, in the 2nd table information about billing amount and date and in the 3rd table information about payment in which bank and how much and when.
Now,
I need to know, customer billed totally, which year, how much paid, how much is the balance?
Please anyone who know do let me know, I really need it.
Thanks
Khalil
Last edited: