[mso] Alert user to possible missing data in Access 2000?

Is it possible to alert the user to possible missing data in Access 2000?

Somehow, the answer will need to use a work-around on Access date
limitations, but I will hold on that for the moment.

My question is of two parts:
1. Suppose a person is born 1875-JUL-20, and there is no death date entered.
2. The user has decided on "102" to be the limit, meaning he wants his
attention drawn to those who have birth dates 102 years (or more) ago but no
death date information was ever entered.

I see the problem of the year 1900 limitation. How then can I work around
this? If it is a VBA solution, is there a source somewhere on the Internet I
can copy it from?

My thinking is this:
I -could- add 2000 to the birth date, get 3875-JUL-20, and use that for a
birth date. (Right?) Then, using today's day of 2005-APR-26 and add 2000 to
be consistent which is 4005-APR-05, and subtract 3875-JUL-20 from
4005-APR-05? At this point (at least in Excel), the result is blank. I am
stymied as to what to do now.

Thank you.

Robert

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: