Date Query Problems

[97rstd]

I need to make some querys for HR functions. I need to be able to query for current calendar month and find 1 month, 6 month, 2 year, and 5 year anniversarys of start date that land in that current month.



So for the one month query I'm using this to find the one month anniversary date and put in a new field called 1month:
1month: DateAdd("m",1,[Hire Date])

Now how would I query that field to be able to report off of any aniversary date landing in the current month and year?

I'm definately an access rookie so speak slowly and use small words!

[aytee111]

This query selects records that are in those number of months. I don't know what you want to do with it next.

SELECT Table1.HireDate, DateDiff("m",[HireDate],Date()) AS NumMonths
FROM Table1
WHERE (((DateDiff("m",[HireDate],Date())) In (1,6,12,24,60)));