Can I change the calendar year beginning date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our fiscal year runs July 1 thru June 30 of each year. I need to track
attendance, gas cards, etc for monthly reports. I have a HUGE table with a
gazillion queries and reports for each one. I need one report to reflect
quarterly output for our fiscal year as stated above. Can I make this report
do that?

Thank you!
 
Create a query to use as the source for your report.

In query design, type this into the Field row:
FinYear: DateAdd("m", -6, [InvoiceDate])
replacing InvoiceDate with the name of your date field.
This yields 2007 for all dates in the 2007/2008 financial year.

If you want to group by quarter, use the expression:
DatePart("q", DateAdd("m", -6, [InvoiceDate]))
 
Back
Top