Calculated data shows in form, but not in table

[cantech2]

I have a table called STUDENTS, some of the fields are SCORE1, SCORE2 AND SUM.

On the form generated from the table, the control source for SUM is =[SCORE1]+[SCORE2].

This works nicely on the form but the calculated figure does not show up on the table. What should I do ?

Humphrey.

 

[KenReay]

Hi

My immedaite answer is NOTHING! why save SUM in the table if you can calculate it ?

But if you insist on doing the unneccessary and dangerous (in terms of data integrity), put a hidden control on your form, bind it to the column in the table to hold the sum (which you have not called sum of course, becuase SUM is a reserved word), then assuming the control containing =[SCORE1]+[SCORE2] (say it is called txtSum), in the before update eevnt of the form put code like so

HiddenSum = txtSum

where HiddenSum is the name of the hidden control mentioned earlier

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK