Transfering age calculation to a table

  • Thread starter Thread starter Shel
  • Start date Start date
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 (e-mail address removed). Any assistance would be greatly appreciated...
 
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.
 
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.
 
Back
Top