select fiscal year on a query

A

artist

I have a query that I need to allow a user to select the fiscal year. The
company fiscal year runs 4/1 through 3/31. I want to allow the user to
select the fiscal year and have the data from 4/1 through 3/31 show on the
report. Any help would be appreciated.
 
A

Allen Browne

Type an expression like this into the Field row in query design:
FinYear: Year(DateAdd("m", -3, [YourDateField]))

By subtracting 3 months, all dates from Jan - Mar fall in the previous year.
 
Top