Formulas?

[NEHicks]

I need to have a field in a database that will calculate the age of a person, based on their DOB. I have it in the excel sheet that I imported into Access to create the data base, but it just copied the number that was already there. When I add new entries into the database, the age isn't calculated. How do I do this?



The forumla I use in my spreadsheet is: =DATEDIF(O2,TODAY(),"y")

[rpeare]

don't store calculated values in a table. common calculations like age should be done in queries or at the run time of a form or report.

your formula would be similar (note, your formula likely is not calculating age correctly if it's in excel)

PersonAge: datediff("yyyy", [Dob], Date()) - iif(DateSerial(Year(Date), Month(DOB), Day(DOB)) > Date, 0, 1)