calculating in tables

  • Thread starter Thread starter hayden watson
  • Start date Start date
H

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
..
 
hayden watson said:
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,
Click to expand...

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).
 
Back
Top