L
Little Rattler
I have just taken over a membership database with records that have several
date fields i.e. Testdate, Renew1, Renew2, etc. The Testdate will obviously
be different for each person as they join our group and I can calculate when
the renew date is due, using dateadd function to add 2 years. Several fields
will be empty as they are some years in the future. How can I find the next
due date for each person when that date could be in any of the 'renew' fields
using a query? Many thanks.
date fields i.e. Testdate, Renew1, Renew2, etc. The Testdate will obviously
be different for each person as they join our group and I can calculate when
the renew date is due, using dateadd function to add 2 years. Several fields
will be empty as they are some years in the future. How can I find the next
due date for each person when that date could be in any of the 'renew' fields
using a query? Many thanks.