Calculating age problems

[Rusty]

I need help !

I took a existing database with a birthdate feild and a age feild. In
the design form view I used controlsource property for the age text
box. It worked in form view to automatically calculate the age from
entering the birthdate. However it doesnt change or add the age to
the table. Any ideas or something that Im not thinking about?

Thanks
Rusty

 

[Douglas J. Steele]

It shouldn't change or add the age to the table: if it did, the age would be
wrong the next time you used the table.

Instead, you should only store the birthdate in the table, and create a
query that includes a calculated field that converts the birthdate to the
age as of the current date.

Use the query wherever you would otherwise have used the table.