0
Are you trying to calculate the age of a person with a specific date in mind? This one stumped me for the longest time, but it is possible using the following formula in a query:
Age: DateDiff("d",[date_of_birth],#9/20/2008#)/365.25
[date_of_birth] is of course the name of the field from which I have pulled the birth date of participants on a table. #9/20/2008# is the date that I am seeking to find the age of the person at that time. If you were to want to see what is was as of now, then you would replace #9/20/2008# with date()
This gets the the age field as accurate as possible. You will need to be sure to have the field allow decimals, otherwise it will round up the amount in the calculated field (for example, 39.6 would round to 40 which would make the participant really adamant about telling you that you're wrong!!)
Be sure to shrink the size of the field in your report to only show the first two digits of age, and you're done! I don't know, there may be a simpler way, but this is how I got through the problem for myself.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What Is a way to calculate the age of an organic object by measuring the proportion of carbon 14 present?
This is known as 'carbon dating'. You can find out how it works from Wikipedia
What do scientists use to calculate the age of an object by measuring the proportions of the radioactive isotopes of v equals certain elements?
See the link below.
What is the age of an object in relation to the ages of other object?
Relative age.
The age in years of a rock or other object is a what?
The age in years of a rock or other object is known as Absolute Age.
What is malinda sapp age?
Reports say that she dies at age 43. Not sure though.
What is a good age for a kid to get a cell phone?
10-11 years of age
The numeric age of an object is called?
Comparative Age
What is the actual age of an event or object?
absolute age
Is it legal in the state of California to keep a seniors medical reports from them?
Unless the patient has legally been ruled incompetent and has had a medical power of attorney or guardian appointed, then they cannot be refused access to their medical records based solely on their age.
Hown ca we calculate Age of a star if its distance from earth is given?
Not enough information. You can't calculate the age, based only on the distance.
When is the normal age for a lady to disvirgin?
What ages is normal to disvirgin
How do you calculate a persons age on Jupiter?
somehow
