If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Grouping..
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! Thanks, Ken |
#2
|
|||
|
|||
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] |
Thread Tools | |
Display Modes | |
|
|