Fiscal Year to Date query for current fiscal year

[Nick McConnell]

I'm trying to query a table and pull all data for the current fiscal year. I'd like the query to work whenever it's pulled be it tomorrow or 3 years from now. I found an IF clause on this website that would seem to work, but it doesn't. Can someone review and point out what I've typed wrong? Our fiscal year is october to September.

IIf(Date()>Year (DateAdd("m",-9,Date())),Betw een DateSerial(Year (Date()),10,1) And Date(),Between DateSerial(Year (Date())-1,10,1) And Date())

Thanks for any suggestions,

Nick

[Sharkiness]

Nick,

Do you want the query to run for this fiscal year or for the fiscal year that the query is run, i.e. if you run it in two years the query would then run for that fiscal year?

[Nick McConnell]

I want to run it for the fiscal year of when ever it's ran. So like you said if I run it in two years, the results will be for that fiscal year, not this fiscal year.

thanks,