Date Calculation

[mrkaye]

Let me try again, I am using access 2010 and I have a database with lots of peoples birthdates, now I have created a new form with first and last names and birthdates, what I am trying to accomplish is there current age with year, month and day. I need a modole to calculate the current age, (25 years 10 months, 3 days) as for example. All help is needed. Marty



If you know a Internet site that has such info I will also like that.

[weekend00]

..........

[ConneXionLost]

mrkaye,

This is the third thread you've started with the same (unresolved) issue:

First

Second

Perhaps it's time for you to post a sample database so we can see what you're doing.

[mrkaye]

I am sending a test file. I need to know how to get my form to have another field with the age in years, months, days from the DOB input.
TIA Marty

[ssanfu]

...<snip> get my form to have another field with...<snip>

Terminology:
Forms have controls (not fields)
Tables have fields


Look here for age calcs:

http://www.rogersaccesslibrary.com/f..._topic215.html

[ConneXionLost]

How to attach a file to a post.

Cheers,