Date between using last date according to PC Date

[Kassy]

I want to make a query to pull out all records between August 01 and October 31st each year but only want the current Year for my report. So if the year is before Dec 31st it will give me this Aug-Sep but if is January up to August then I want last years Aug-October. This statement gives me 1 years records but I dont know how to modify it to set a date using only the mmdd then use system year? E.g. Between "0801" to "1031" using the last August Year. If that makes sense!
Between
Iif (Format(Date(),"mmdd")>"0801",DateSerial(Year(Date()),9,1),
DateSerial(Year(Date())-1,9,1)) And Date()

 

[Kassy]

Thank You

thank you -will have a look at the example -as well as some of the others!

 

[Kassy]

Too complicated

Checked out the db but it is too complicated for my needs. I just want a query (or report) that can be run usually before December or maybe in January every year to check which payments have been made during the 'Last' August, September and October months, if so I can print out a list(report) which shows which members are allowed certain privileges. I dont want to have to input a date I want it to run according to the system date and then, each year when run, it will automatically show the latest Sep-Oct months!