calculated field

[Guest]

Is there a way to update a field after calculation? I used an unbound field
to calculate the age =now()-[BirthDate], now I want to put this value to a
field Ages on the database. Or is there another way? Otherwise what purpose
what does a calculated field purpose is? Thanks

 

[Guest]

Don't ever store calculated information in fields. Just keep it to a query.

 

[Joseph Meehan]

Don't ever store calculated information in fields. Just keep it to a
query.

Unless of course what you want to store will be an historic number and
not a current number. Something like an age will change. You may want to
know that Johnny broke his arm when he was 7 years old a year from now, but
Johnny will not be 7 years old.

As scubadiver suggest most people make the mistake he is warning about.