Grouping records on Report by fiscal months 1

[Zuzia]

Hi,

I have a question about groupings. I need to group months on a report, but they are fiscal months, meaning that they run from the 15th of the first month to the 15th of the next month. I want all the fiscal months to be grouped individually per page, but all per report. So far the "Group and Sort" property does not seem to have that kind of functionality. Any suggestions?

Thanks,
Z

 

[THWatson]

Zuzia
Here's a link to the Microsoft Knowledge Base that shows how to get the fiscal year or month.

http://support.microsoft.com/?kbid=210249

Tom

 

[Zuzia]

Thanks so much Tom! That is exactly what I was looking for and it works very well.

Z