Rolling monthly totals by quarter and year

[beacon]

Hi everybody,

The title probably won't do this post justice, so I apologize ahead of time. Here's what I'm trying to accomplish...I have a report currently that shows totals for a date range that the user enters through a form. Typically, the user will enter a fiscal quarter for the date range (max of 92 days), as that's our normal reporting period for this particular report. Just for reference, our fiscal year starts in September.

My requirements have changed and I'm being asked to not only provide the data for the date range that the user entered, but also for the other months not included in the date range, up to one year. So, if the user enter September 1, 2009 for the start date and November 30, 2009 for the end date, the report should return November 1, 2008 through November 30, 2009, preferrably with the date range parameter data highlighted or bolded.

I've got a parameter field in my query that pulls the parameter from the form, and I tried using DateAdd to calculate the dates, but it only recalculated how the dates are displayed instead of actually modifying the date range.

Is it possible to accomplish this or does anyone have a better approach for me to take?

Please let me know if more info is needed and, as always, thanks for all the help...

beacon

[beacon]

I'm sorry, the date that should be returned is wrong. It should say December 1, 2008 through November 30, 2009.