By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,968 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,968 IT Pros & Developers. It's quick & easy.

Recording Dates of Births on Access

P: 1
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(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))

Any help is apprepiated, thanks...
Jul 27 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.