Flag Records Based on Birthdate

[WillYum]

I'm looking for the necessary code to flag records based on birthdate of a client. Certain actions need to be taken when when they turn 5, 14, and 18. Never the same action. They should be flagged until the the phone call, letter, etc, has been done.

Obviously I was thinking three different queries, one for each age. I just not sure what coding (if any, since Queries might be enough) would be needed. I'd love to hear any suggestions.

- William - William ~^~ ~^~

~ W . I . L . L . Y . U . M ~
wOrLd WiDe WhAt?

 

[zevw]

I would run a regular Select Query:

You would select where the Month and Day equal todays date.

The Year Function:

Minus this Year from the BirthDate Year and in the criterea set where year = 5 or 14 or 18