Access 2007

C

ccinseward

I need to calculate an age based on 2 specific dates that won't change. It
will never need "updating".
I've read all the posts on doing this and I understand that you aren't
supposed to store calculations in a table. But it is not clear to me where or
how to store this information. If I store it somewhere else will it show up
in the table or will I have to retrieve it everytime I open the database.

cc
 
J

Jeff Boyce

The concept is don't store it, period. Not anywhere.

Instead, use a query to do the calculation. You can use the query as a
source for a form or a report.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top