Displaying a calculated value

[Deeds37]

I wanted to calculate the current age of a contact using information from
another column i.e date of birth. I used a formula available in tutorials and
it worked. I see the current age in an text box on the form.

When I go to the datasheet I do not see the age. The value is 0. What do I
do to show the age in the datasheet. Do I need to create another column with
some formula? Because I need queries that show ages of contacts.

Thanks in advance.

 

[Daryl S]

Deeds37 -

You do not want to store the age in the database - it is always changing!
Instead, calculate it on any forms or in any queries you need to use it in.

 

[Deeds37]

Thanks Daryl, I am still learning MS Access and find the 2007 version really
helpful. I now understand that it is better to calculate the age in the
query. Is there a formula if I pull the first name, last name and date of
birth from a table in a query. the format of the date of birth is mm/dd/yyyy

Thanks.