Saving a Form field into a table

[vand_uk]

Help!!
I have a form created on a query. I created a field to add up the cost of all components on the form and now I need to save it to a field in a table so that I can run a report (my invoice)! Any suggestions??

 

[neileg]

You don't need to save this value. Base your report on the query that includes the calculated value.

 

[vand_uk]

Many thanks,
My report is based on the query, but my calculation is on my form not in my query. Where in the query do i enter it?

 

[neileg]

Add a new calculated field in the query grid. In the first empty column where you would enter the field name, add your formula like this

NewField: [MyField1]+[MyField2]+[MyField3]

NewField will then appear as a field in the query results (note the colon and no equals sign). You can then use this in your report. You could also take the calculation out of your form and use this field. This might help smooth the transition if you scroll from one record to another in the form as the caculation will already be in the query.