Date queries

[DeborahP]

I have a database that we use to keep up with employees who are delinquent in their training. I am not concerned with MM/DD/YY format to extract people. I want Month only. Our fiscal years runs from Oct to Sept. I want people from 11 (Nov) to 5 (May) to print on my report. Currently, the query is pulling from 5 to 11.
Is there a way to make it work the way I need it?

Please help!

Deborah