Fiscal Year date shenanigans

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