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

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...

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.