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
Figuring fiscal year based on formatted date 2
Current fiscal year 8
Query current fiscal year 2
Date query, subtract 3 months 10
Re: How can I convert a date to a FISCAL year 0
Fiscal Year in Access 5
Get fiscal year to show in a report 4

Top