HI
Im working on a form in an Access 2007 database where I have two seperate fields on the form that I would like to add together and enter it into a third box on the same form upon submit. The fields I would like to add together are [labor] and [material]. When the submit button is pushed on the form I need the total to be entered into the field called [totalcost] and saved. I've read about using a query to do this and I created one that sums up labor and material successfully but when it comes to placing the [totalcost] field on the form, i'm not sure how to proceed. So far all I get is an error.
Im working on a form in an Access 2007 database where I have two seperate fields on the form that I would like to add together and enter it into a third box on the same form upon submit. The fields I would like to add together are [labor] and [material]. When the submit button is pushed on the form I need the total to be entered into the field called [totalcost] and saved. I've read about using a query to do this and I created one that sums up labor and material successfully but when it comes to placing the [totalcost] field on the form, i'm not sure how to proceed. So far all I get is an error.