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!

Register Log in
  • 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

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.

Similar threads

SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
752
dhookom
dhookom
JohnXr
  • Locked
  • Question
thread703-757058 I use the followi
Replies
4
Views
473
Axworthy
Axworthy
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
425
sxschech
sxschech
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
942
caykamanj1966
caykamanj1966
RonMcIntire
  • Locked
  • Question
Adding variables to a control in a footer 1
Replies
4
Views
345
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top