I have a database for a carpet cleaning business.I want to be able to send
out reminders if has been over a year since I last cleaned a person's
carpet. But I DON'T want to send out a "year notice" a month after I just
sent one out(A year and a month out).

Each row has: Date of service, First name, last name, address, date of
mailing.

I want to be able to have another column that will alert me if the latest
date of mailing is over a year old. Then I will know it is time to mail a
reminder again. Obviously if I service a person's carpet six months after I
last mailed them a notice I want the alert column to "change" to alert me
when it has been a year since I last serviced their carpet NOT since I last
mailed them a notice which was earlier.
I hope this is making sense. Thanks for any help. Jim