Anniversary Date Help

[VeronicaCBurgess]

I have a database that I am building to track the anniversary dates for tenants. I have a query that with the field [beg_date] and the following which will return the entire years worth of anniversary dates.

Anniversary: Format([beg_date],"mm/dd&quot & "/" & Format(Date(),"yyyy&quot

Is there a way to isolate just the upcomming anniversary dates for the rest of the year, ie July forward?

Thanks

 

[mpastore]

This will return all records from next month to the end of the year (if December will roll to January):

select * from mytable
where month([beg_date]) between iif(month(date())=12,1,month(date())+1) and 12


Mike Pastore

Hats off to (Roy) Harper