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

calculating age from DOB and adding to table

P: n/a
I have a form that calculates age when you enter the DOB. Everything I
enter on the form gets input in the table. However, the age doesn't get
input. How can I get it to input the age? I know I'm being vague, but I
don't know how else to explain it. Please help.

Thanks

Dec 28 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Rachel,

Is the control you are using to display the returned calculated date
bound to a field in the table in which the other data on the form is
stored? There might be a slight issue with saving this information in
your table as the data will represent the age at the time when the
record was created (and therefore would remain static) unless changed.
You may want it to do this...or you may not. Another alternative would
be to recalculate the age each time you wish to view the age in order
to show the persons age each time you view it. Hope this helps...will
check back to see how you go :)

Anton

Dec 28 '05 #2

P: n/a

"rachel_a" <rr*****@nmlottery.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
I have a form that calculates age when you enter the DOB. Everything I
enter on the form gets input in the table. However, the age doesn't get
input. How can I get it to input the age? I know I'm being vague, but I
don't know how else to explain it. Please help.


It is not a good idea to store a value that you can calculate in a query,
form, report, or VBA code when you need it. If you have a need to store "the
person's age when data about him/her was first entered", it would be valid.
In that case, use VBA code to copy the calculated value into a Text Box that
is bound to the appropriate Field in the Record Source.

If it just represents the person's age, that will change over time... and
can always be calculated from the saved DOB.

Larry Linson
Microsoft Access MVP

Dec 28 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.