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,

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...