calculated field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want a calculated field to appear in my form. I can do it but then the
calculated value does not show up in the able associated with the form. How
do i remedy this?
 
onropjack said:
i want a calculated field to appear in my form. I can do it but then
the calculated value does not show up in the able associated with the
form. How do i remedy this?
Click to expand...

Calculated values should not be stored in the table. Just use the
expression you have now to calculate the value whenever you need it.

If you want to avoid writing the expression over and over again then build a
SELECT query based on your table and add the expresson as a calculated field
in the query. Then just use the query every place that you would otherwise
have used the table (and remove the field from the table entirely).
 
Back
Top