Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hello everyone, I have created a

Status
Not open for further replies.

nogo

Technical User
Sep 4, 2002
1
DE
Hello everyone,

I have created a report grouped by customers.
For each customer I have the accounts receivable (ar)with dates.
Now I want to do an aging on each customer which means I have to select the ar in relation to the date.
For example
I want the Sum of ar where date is between today and (today - 30).
Anyone has an idea how I can access the different recordsets (?) and evaluate them?

THX a lot in advance
Raoul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top