Re: Missing Data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Klatuu and John,

The expression worked....The database I created is for a study that requires
age not DOB and we are just looking at a single time point not over time.

THANKS so much for your replies.

"Klatuu" wrote:

Thanks for additional information, John.
I was not aware that HIPPA considered DOB restricted info.
I have never personally seen a situation where DOB or age were an issue of
security. I have seen where age at entry was kept, but even then we
calculated off DOB which was stored and used for other things.
--
Dave Hargis, Microsoft Access MVP


"John Spencer MVP" wrote:

Klatuu,
You are making an assumption that the database is collecting the date of
birth. Some times all that is collected is the age of the person at the time
of the event being recorded. Date of Birth is an identifier that is sometimes
used in security systems and is also considered in health related databases
(in the US) as restricted information (personal health information).

I agree that in many (if not most) cases it is best to collect the date of
birth and calculate the age when needed.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Klatuu wrote:
Age Group: IIf([Age]<40,"40<",IIf([Age]>=40 And
[Age]<60,"40-60",IIf([Age]>60,"60>", "***Missing***")))

One other point. It appears you are storing an age in your table. Bad
idea. ages change over time and it is a value that can be calculated. The
correct method is to store the person's birthday and calculate the age based
on the birthday when you need to reference the person's age.

.

Relevant Pages

  • Re: Id like NOT to see something on my form.
    ... For those whose year of birth I know, ... The union query mentioned below was developed in order to combine DOB & DOA ... have a second field which calculates age. ... Add an unbound control to your form. ...
    (microsoft.public.access.forms)
  • Re: How do i link data from a Word form to a database
    ... filled in the form to a database. ... I have fields like name, Date Of Birth, age, Address,and file number. ... My goal is to have my employees fill this form out and keep a record of the fields so I may pull up the information in the future ...
    (microsoft.public.office.misc)
  • Re: A date function in Access using VB
    ... Dim currentSeason As Date ... ' put the age on the form ... Doug Steele, Microsoft Access MVP ... DOB and the playingAge are bound to a database. ...
    (microsoft.public.access.formscoding)
  • Using Code
    ... searching for how I can correctly show age in a database I am making, ... DateDiff("y", DOB, Date) ...
    (comp.databases.ms-access)
  • Re: index card
    ... My excel spreadsheet is the equivalent of index cards - I list each person - ... their parents, spouse, occupation, dob, dom, dod, locations for each and age ...
    (soc.genealogy.britain)