Vacation totals by fiscal year

  • Thread starter Thread starter Rudy
  • Start date Start date
R

Rudy

I'm trying to track vacation total by the fiscal year
rather than the conventional year. I have a query that
sums to vacation used by the annual year. How do I
modify the query to calculate it for the fiscal year ir
from 01 Apr 03 - 31 Mar 04 etc.
 
Use a query as the source for the report.

In the query, enter a calculated field:
FisYear: Year(DateAdd("m", -3, [SomeDateField]))

Group on this field.
 
You must log in or register to reply here.

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

Vacation by fiscal year Pt 2 1
select fiscal year on a query 1
Calculating fiscal year for two dates in query 5
Fiscal year 3
select dates for last fiscal year 3
Column Total 3
Fiscal year 2
Fiscal Years Query 3

Back
Top