 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Report totally
I have several reports that mgmt needs to have totally on our fiscal year; not the calendar year. Currently, the report is totally on a week, on a month, and then on a year. Everything is working just great but the totally on the year. Our fiscal year goes from 11-1 to 10-31. How do I tell the reporting to use the time frame I need? Thanks for you help. Use an additional field just for Fiscal Year -- Fiscal_Year: Format(DateAdd("m", 2, [YourDateField]), "yyyy")  SignatureKARL DEWEY Build a little - Test a little > I have several reports that mgmt needs to have totally on our fiscal year; > not the calendar year. Currently, the report is totally on a week, on a [quoted text clipped - 3 lines] > > Thanks for you help. Karl, Thanks for responding so quickly. Unfortunately, I must have not explained the problem enough or I don't understand your response. These reports are using the 'Sorting and Grouping' feature to create breaks and totals where they should be happening. The report is fed a 'Week Ending Date' and on the Group On function we select Week, Month, or Year. Where would I put your solution? Thanks > Use an additional field just for Fiscal Year -- > Fiscal_Year: Format(DateAdd("m", 2, [YourDateField]), "yyyy") [quoted text clipped - 6 lines] > > > > Thanks for you help. You would put my post as a new field in the query design view grid. I take the actual calendar date and converts it to a Fiscal Year for sorting and groupting. SignatureKARL DEWEY Build a little - Test a little > Karl, > Thanks for responding so quickly. Unfortunately, I must have not explained [quoted text clipped - 18 lines] > > > > > > Thanks for you help. YOU ARE ABSOLUTELY AWESOME!!!!! Works like a champ! Thanks so much! > You would put my post as a new field in the query design view grid. I take > the actual calendar date and converts it to a Fiscal Year for sorting and [quoted text clipped - 22 lines] > > > > > > > > Thanks for you help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.