select fiscal year on a query

  • Thread starter Thread starter artist
  • Start date Start date
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.
 
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.
 
Back
Top