Report Grouping..

  • Thread starter Thread starter Ken Weilbacher
  • Start date Start date
K

Ken Weilbacher

I know this is going to sound like a lame question but I
can't find any documentation on how to do this in Access
Reports.

I have a calculated value that uses the datedif function
so that I can tell how many days between two given dates
in the report. I want to group them in 30 day intervals
so that in the report it groups them by > 30 and > 60 and
90... For example... How do I do this!
Click to expand...

Thanks,

Ken
 
Ken said:
I have a calculated value that uses the datedif function
so that I can tell how many days between two given dates
in the report. I want to group them in 30 day intervals
so that in the report it groups them by > 30 and > 60 and
Click to expand...


Not sure about your details, but maybe you can group on the
expression:

=DateDiff("d", datefield1, datefield2) \ 30
 
Back
Top