Summing values on a form, then further entering in table

[Beau]

Hey there, Im currently making a form so users can enter project information. For this particular project, the user must choose from a variety of options, and each option has a number value assigned to it for a rating. Now at the end of this form, I want a sum of the ratings, and then entered into the table. I am using a text box for the sum of ratings, and can get the sum of ratings to work on the form, but this data is entered as a 0 in the table. If anyone could help me find a way to put the actual sum in the table, that would be excellent.. thx a lot.

If it would be any help, here are the names of text boxes that I'm adding:

Health and Safety Rating, Maintenance Rating, Equipment Rating, School Size Rating, Student Enrollment Rating, SD Priority Rating, Project Requested Previously Rating

Those ratings must be added into "Total Rating"

Thankyou!

 

[KenHigg]

Hum... Unless you have extenuating circumstances, my advice would be to not save the sum, but rather calculate it on the fly where ever you need it...It's kind of a general database design guideline....

 

[Beau]

But I want this calculated value to be stored in the database

 

[KenHigg]

Can you offer a good reason why?

(I'm not trying to be smart, it's just that there are good reasons why not to )

 

[RuralGuy]

Beau,

Here's what MVP Allen Browne has to say on the subject: http://allenbrowne.com/casu-14.html