Calculation in a table

[spcepickle]

Hi all - I have a table that is keeping track of projects we are working on. There is a field with the overall cost of the project and a field with the percent paid. I would like a field that calculates that amount still owed. Is this possible?

Thanks!
Amelia

 

[m.shakeebahmed]

yes it possible....for this what my understanding is you need to VBA... populate the records set and with each record, do the calculation and update the third field...

 

[GolfProRM]

The recommended solution would be to build a form to view the data you need, then create an unbound textbox with a control source that completes your math. Storing calculated data in a table is generally not recommended.

The nice thing about the form is that whenever the cost or percentage changes, the amount owed will automatically update and show the correct information.