Can I change the calendar year beginning 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!
 
A

Allen Browne

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]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another question on fiscal year reports 2
How do I convert a date to a fiscal year? 5
How can I get pivot table to order months by our fiscal year? 1
Reports that compare month/year totals 5
this month and year to date side by side 1
Criteria for results in report of previous year 5
How can I compare yearly shipped side by side (column) per part nu 1
Monthly Calendar Report 5

Top