Query results based on current month to 3 months out

[clmarks]

I have searched this forum and found (and tried) a number of examples of similar problems, but they have not worked for me. I am running out of time.

I have a date field (HireDate). I need to look at the month part of that field and pull the matches for the current month and the next two months. The resulting list should show me everyone who is due for an annual review this month, next month, and the month after.

It seems like it should be pretty simple, but I've been beating my brains out for two days.

I would very much appreciate any help provided.

 

[pbaldy]

You should find functions here to find the two appropriate dates to use with "Between":

http://www.pacificdb.com.au/Support/code_datetime.htm