Transfering age calculation to a table

S

Shel

I have an age calculation in a form, and it works perfectly. It doesn't store
in the table. From what I have read, it isn't supposed to store in the table.
The problem comes when I create a query or report. The age field pulls in at
zero instead of the calculated result. Please help! Also, I tried asking this
question before and was unable to read the answers. Please respond directly
to [email protected]. Any assistance would be greatly appreciated...
 
D

Douglas J. Steele

Put the calculation into a query, and use the query as the recordsource for
the form.

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

Douglas J. Steele

Create a new query. Select the table in question and drag all of the fields
from the table into the query grid.

In an empty column in the grid, put the calculation you're using to get the
age.
 
Top