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.
What else can I help you with?
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 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 the age of an object in relation to the ages of other object?
Relative age.
What is malinda sapp age?
Reports say that she dies at age 43. Not sure though.
What The numeric age or actual age of an object is called?
The numeric age or actual age of an object is referred to as its "absolute age." This term denotes the specific age of an object in years, determined through methods such as radiometric dating or other scientific techniques. Absolute age provides a concrete timeline for the object's formation or occurrence, as opposed to relative age, which only indicates whether an object is older or younger compared to others.
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
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.
How old am I alanah mccorvey?
I'm sorry, but I don't have access to personal information about individuals unless it has been publicly shared. If you provide your birth year or age, I can help you calculate how old you are.
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.
