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.
 

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

select dates for last fiscal year 3
Query current fiscal year 2
Current fiscal year 8
Calculating fiscal year for two dates in query 5
Fiscal year 3
Fiscal Month Query 4
modify crosstab query to fiscal qtrs rather than calandar qtrs 5
New column to get fiscal year from existing dates 8

Top