answersLogoWhite

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.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

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.


What type of dating uses the properties of atoms in material to determine an object's age?

Radiometric dating uses the properties of atoms in materials to determine an object's age. This method relies on the principle of radioactive decay, where unstable isotopes in the material break down into stable isotopes over time at a known rate, allowing scientists to calculate the age of the object.


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


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.


How does light determine the age of object in the universe?

Light from distant objects in the universe allows scientists to determine the age of those objects based on the time it takes for the light to reach us. The farther away an object is, the longer it takes for its light to travel to us, giving us a glimpse into the past. By measuring the redshift of the light, scientists can calculate the age of the object based on the expansion of the universe.


The age in years of a rock or other object is a what?

The age in years of a rock or other object is a representation of the time that has passed since its formation. This age can be determined through various methods such as radiometric dating or relative dating techniques.


How do you calculate age using carbon dating?

When a living thing dies, it stops taking in carbon-14, and the carbon-14 decays into nitrogen-14 at a steady rate. By measuring how much carbon-14 remains, scientists can estimate how old a specimen is.


How can radioactivity be used to find the age of an object?

Radioactivity dating is based on the principle that unstable isotopes decay at a predictable rate, known as a half-life. By measuring the amount of remaining radioactive isotopes in an object, scientists can calculate how long it has been since the isotopes were formed, thereby determining the object's age. Common methods include carbon-14 dating for organic materials and uranium-lead dating for rocks and minerals.