Multiple summary total in a report

[vnms2001]

Hi All,

How can I generate a report that contains multiple summary total by year. I run the query to give me selected time period(s) for my report. For example: I want to have the summary for the date ranges from the year 1994 to 2001, and then 2002, 2003, 2004 etc. I'm having difficulty for the first summary total which is the date range from 1994 to 2001. Please advise.

Thank you

[June7]

You want a 'rolling' summary - meaning a total through each year: 1994-2001, 1994-2002, 1994-2003, etc?

Maybe this helps http://allenbrowne.com/subquery-01.html#YTD

[vnms2001]

I like to see summary for 1994-2001, 2002, 2003, 2004 etc

[June7]

Then you want to lump 1994-2001 as one group and every year after individually?

Build a group section in report with expression:

IIf(Year([date field])<=2001, 2001, Year([date field]))

Or calculate that in query to create a field that can be referenced in report.