If I have a mailing list database of 300 members.Suppose I have the dates each person renewed and paid their subscription.
How could I use MS Access 2000 version 9.0 to flag or alert me as to the exact date a persons subscription is due for renewal. The long way would be to do a query for each day of the year, which is not practical.


Thanks