Use Calculated fields in form to update table

[KarenS]

I have a form created from a table and I had to use calculations in some of the fields to automate certain processes. Now, if I pull a report based on the fields in the table - I am getting all except for the fields with the calculations. Is there any way to update the main table - since most of the calculations were done with text boxes?

 

[reclusivemonkey]

There are two approaches here; you can repeat the calculation fields in your report, or you can write the results of the calculations to the original table or a new table linked to the original. You can use an update query to add data to existing records.