I have a database that I use for Dates of Births, but I want the database to calculate the age of person when I enter the date of birth in a text box, I have a formula done but when I enter a date in to 1 record all the records are updated with the same date of birth, would you know if there is a way that each record can hold a different date of birth and calculate the different ages. Also, when i close the form and re open the database the dates of birth that i have already entered have disappeared. The code i'm using is the following:
=DateDiff("yyyy ",[Birthdate],Now())+Int(For mat(Now(),"mmdd ")<Format([Birthdate],"mmdd"))
Any help is apprepiated, thanks...
=DateDiff("yyyy ",[Birthdate],Now())+Int(For mat(Now(),"mmdd ")<Format([Birthdate],"mmdd"))
Any help is apprepiated, thanks...