View Single Post
  #2  
Old May 18th, 2004, 05:33 AM
Marshall Barton
external usenet poster
 
Posts: n/a
Default Report Grouping..

Ken Weilbacher wrote:
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...



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

=DateDiff("d", datefield1, datefield2) \ 30
--
Marsh
MVP [MS Access]