Fiscal Year date shenanigans

R

roger111

Hi all,
need some help with managing dates for a fiscal year vs. a calenda
year. If the fiscal year starts in Oct (i.e. this October will be Oc
05, in fiscal year terms), and I want to limit a query to the curren
fiscal year in a table spanning over four years, how do I do that? An
help would be appreciated.
Roge
 
A

AMCLFC

Hi,

Make a select query of the data, in the criteria field for the dat
culumn you want to filter type >[start date] & <[end date] then acces
will promt you to put a start date and end date to filter yourt record
b
 

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

End of Quarter Based on Fiscal Year 2
Fiscal YTD Filter 7
Get fiscal year to show in a report 4
Query current fiscal year 2
Extracting Month and Year For a Given Date 1
Calculating fiscal year for two dates in query 5
Fiscal year 3
Counting Unduplicate in Fiscal Year 1

Top