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

Hi Robert.  I don't have any idea what you're talking about in your
"thinking" so I simplified it...if I had to do something like this....

My sample has 2 fields, born and died.

I have a query that calculates age.  For example if a person is born
08/25/1859 and died 04/25/1933, he was 145.
 HowOld:
DateDiff("yyyy",[born],Now())+Int(Format(Now(),"mmdd")<Format([born],"mm
dd"))=20

The next step would be to create a conditional query that checks the
calculated age. Confirm: IIf([HowOld]<102,"OK",IIf([born] Is Null Or
[died] Is Null,"Confirm Dates","OK"))

I'm sure it should be more complicated than that to cover all the
possibilities and I just threw this together so it probably won't even
work but you get the gist.

Hope this helps. /glenda

-----Original Message-----
From: Robert Carneal [mailto:carnealre@xxxxxxxxxxxx]=20
Sent: Tuesday, April 26, 2005 02:44 PM
To: mso@xxxxxxxxxxxxx
Subject: [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
*************************************************************

*************************************************************
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: