age calculate on form wont show in table: need age for reports

A

Andrew

i work on access as my tool for lots reports:
when i made a form and create the birthdate and year area for input data,
the age get calculate fine: But: age dosnt show on my main table from which i
will make my reports: How i fix this? Age data its a must for reports i have
to made on students.
 
A

Al Campagna

Andrew,
A calculated field is just a "displayed" value on the form. It's not "bound" to a field
in your table, so it never gets saved.
And... that's the correct way to do it!

Never save a calculated value that can re-derived from data you already have
Since you've captured the BirthDate, you can always re-calculate the age from that... in
any subsequent form, query or report.
On your report, in the query behind it, create a calculated column like this...
Age : (Put the same age calculation as on your form here)
Now place that Age field on your report.
 
A

Andrew

Al Campana: You help a lot on this issue, Thanks for consider my request on
this matter. "Bow"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top