By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Rolling monthly totals by quarter and year

beacon
100+
P: 579
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
Mar 1 '10 #1
Share this Question
Share on Google+
1 Reply


beacon
100+
P: 579
I'm sorry, the date that should be returned is wrong. It should say December 1, 2008 through November 30, 2009.
Mar 1 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.