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.
 
Back
Top