Query Help Needed to sort based on months

[Stewwy]

I am building an employee tracking database for pilots. In the end of their birth year they have annual evaluation criteria that must be met within a 3 month period, example: January birth month must complete evaluatable criteria between November and January. I have all of the evaluations and birth months built into my data table, and can not figure out how to build a query to display only personnel whose birth month is the current month and the preceding two to fill a report form where i can track completion of evaluations for all persons in their annual window. I'm sure there's a simple answer, but i'm fairly new to access and learning as i go based on my needs - thank you in advance for your assistance!

[CJ_London]

presumable your problem is if current month is Jan - how to pick up Nov and Dec?

[Stewwy]

that would be the next step, i can't figure out how to write the base query currently. much less how to have it wrap around the end of the year

[ranman256]

Use this query...
Select person, birth, month(dateadd("m"-2,birth)), month(birth) from table