mswilson16
Programmer
Hi all,
I am trying to create an aging report. I have two tables, Client and Accounts. Client stores the client information (name, credit limit etc etc) Accounts stores payments and invoices. I need to be able to create a report that will tell me the clients balance as of a certain date, and also tell me the aging of the balance as of the specified date.
I figure that I will need an if statement to say if the accounts record is of a type of P or I, if P then it goes as a minus to the total, and if I then it goes as a positive.
Then I need to be able to say how the balance ranges over 0-30, 31-60,61-90 days...
If someone could help me that would be great.
Thanks in advance
mswilson
I am trying to create an aging report. I have two tables, Client and Accounts. Client stores the client information (name, credit limit etc etc) Accounts stores payments and invoices. I need to be able to create a report that will tell me the clients balance as of a certain date, and also tell me the aging of the balance as of the specified date.
I figure that I will need an if statement to say if the accounts record is of a type of P or I, if P then it goes as a minus to the total, and if I then it goes as a positive.
Then I need to be able to say how the balance ranges over 0-30, 31-60,61-90 days...
If someone could help me that would be great.
Thanks in advance
mswilson