calculating in tables

[hayden watson]

hi,
Im building a database for a business to help the keep
track of their employee's pay.
In a form i have several input fields and another field
that calculates the data.
In the calculating field, the controlsource is "=[Normal
Pay]+[Overtime]+[Additionalpay]".
But since i changed the control source to do the
calculation it doesnt appear in the table.
Could you please show me a way of getting the data from
the calculating field into the table.
Thank you for taking your time reading this,
Hayden
..

 

[Rick Brandt]

hi,
Im building a database for a business to help the keep
track of their employee's pay.
In a form i have several input fields and another field
that calculates the data.
In the calculating field, the controlsource is "=[Normal
Pay]+[Overtime]+[Additionalpay]".
But since i changed the control source to do the
calculation it doesnt appear in the table.
Could you please show me a way of getting the data from
the calculating field into the table.
Thank you for taking your time reading this,

You don't. Calculations belong in forms, queries, and reports. Not in tables.

Create a query based on your table but add one extra field to perform the
calculation. Then use that query every place that you are currently using the table.
(delete the field from the table).