Group data into 5 year cycles

  • Thread starter Thread starter diarmuidq
  • Start date Start date
D

diarmuidq

On my report, I want to group by TranDate. I set it as a group header, and I
can see Group on Year. How would I do that for 5 years?
Thanks
Diarmuid
 
Hi Diarmuid,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

If I understand you correctly, you already have a group header for the
TransDate and are grouping by year. To have it group by 5 year intervals,
simply change the Interval for the groupby to 5 and it will literally put 5
concurrent years of totals in your detail section. Remember, however, that
if the first record TransDate was 4/1/1995, that the grouping will not
break at 4/1/2000. It would end the group at 12/31/2005.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top