Column Report Formatting

  • Thread starter Thread starter SteveK
  • Start date Start date
S

SteveK

How do I get one number to be printed in a column based on
another number which has been calculated in the same
table? The application is an Acccounts Receivable Aging
Report similiar to many accounting systems, where invoice
amount is put in a "bucket" column based on the number of
days it is outstanfing. I use DateDiff to get the number
of days outstanding, but cannot figure out how to get it
to print in one of 5 "buckets" of which each has a range
of days i.e. 30-60 days.

Thanks.
 
Steve,

There would be a number of approaches to this. One approach would be
to use calculated fields in the query that the report is based on to
get your 5 buckets. Something like...
Bucket2: Abs(Sum([Amount]*[YourDate] Between Date()-60 And Date()-31))

- Steve Schapel, Microsoft Access MVP
 
Back
Top