search on anniversary date

[Rod]

Greetings,

I am trying to run a perpetual query that will return
results on a date field on an anniversary date of the
current year without having to go into the query each year
and adjust the date to reflect the current year.

For example. To return all records that have a date of 31
Mar 2004 (this year).
When this same query is run next year it will return all
records that have a date of 31 Mar 2005 (next year), and
so on...

Any help would be greatly appreciated.

Rod

 

[Graham R Seach]

Rod,

SELECT * FROM tblMyTable WHERE Format(myDate, "mmdd") = "0331"

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia