Calculated field in a table?

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I am trying to fix an access file that seems to have been
built using a calculated field in a table. This field
(Pay) multiplies one field (Hours)in the table with
another field (Wage) in the same table. Whatever was in
this table that made it work is no longer evident as it no
longer works. How do calculated fields in tables work and
how can I restore that function to my table?

Thanks Dennis
 
Dennis, the best design is *not* to store the calculated field in the table.
Instead, use a query to get the calculated result, and it can never be
wrong.

1. Delete the field from the table. Save.

2. Create a new query into this table.

3. Type into the Field row of query design:
Pay: [Hours] * [Wage]

4. Drag the "*" from the top of the table into the query so it contains all
the other fields.

5. Change the RecordSource property of your form/report etc to the name of
the query instead of the table. Since you used the same name ("Pay") for the
calculated field in the query, everything will now work as normal.
 
Back
Top