Add a new text box. In the control source add this...
= DateAdd("d",[DateOfBirthField],Date())/365
The Date() is a system function that returns today's date.
You will also need to adjust the decimals on the textbox to your needs.
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
----- Original Message ----
From: spinlock9 <[EMAIL PROTECTED]>
To: [email protected]
Sent: Monday, October 16, 2006 5:43:40 PM
Subject: [ms_access] newbie
I do volunteer work for a small not-for-profit. I know very little
about Access. I put an Excel spreadsheet of client data into a table
and am working up a form. One of the fields in the table is date-of-
birth. How can I get a peson's age using that field into a form? I
have seen a formula to do it, but have no idea how to get it into a
form.
Thanks for any help.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
