help doing some math.

I have a database that has 2 tables one called tblPlan and one called tblCoF. I have a spreadsheet that folks were using along with this database and in the spreadsheet it did some math formulation. I now have put all the fields from the spreadsheet into tblPlan and all the math factors into tblCoF. and here is how the math is done using the fields in the database.
Priority =  ([tblplan].[capacity]*[tblCoF].[capacity factor])+(0)+([tblPlan].[product quality]*[tblCoF].[product quality facor])+([tblPlan].[major equipm avail]*[tblCoF].[major equipm avail factor])+([tblPlan].[reliable supply to customers]*([tblCoF].[reliable supply to customers factor])+([tblPlan].[Maint cost perf]*[tblCoF].[Maint cost perf facotr])+([tblPlan].[conversion cost perf]*[tblCoF].[conversion cost perf factor])+([tblPlan].[Energy Efficiency]*[tblCoF].[Energy Efficiency factor])+([tblPlan].[EHS Performance emmisions]*[tblCoF].[EHS Performance emissions Factor])+([tblPlan].[EHS Performance Events]*[tblCoF].[EHS Performance Events factor])+(tblPlan].[EHS Compliance]*[tblCoF].[EHS Compliance Factor])+([tblPlan].[Economic Benifit]*[tblCoF].[Economic Benifit factor])+([tblPlan].[Energy Diversity]*[tblCoF].[Energy Diversity factor])

so basicly in tblPlan I also have a field called priority and the result of this math I want to store in that filed. How can I do this? There is a save button at the bottom of the form where the person inputs all the data into tblPlan and i figure it would be good to do the math when they click save but just dont know how to do it.
Start Free Trial