Vacation totals by fiscal year

[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.

 

[Allen Browne]

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.