how to sum access page fields and store total in table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to sum several fields on a data access page, and save the calculated
value, displayed in another field, back to the Access table. I can do the
summing, and show the total, but I can't get the Data page to save the total
back to the table for me.
Someone must know what I'm doing wrong?!
 
Jim:

Good database design standards would dictate that you not store a calculated
value in the table. This is redundant. When you need the value, just
calculate it.

There are exceptions to this. If youhave a variable number (exchange rate,
price paid for a stock, etc.) then you may have a valid reason to save the
figure.

If so, post back and someone can give you further direction.

In general though, this would not be the way to go.

Rick B
 
Many thanks, Rick, that has put me straight!
As you say, it's just as easy to calculate the value whenever it is needed.
Why didn't I think of that before!
Cheers,
Jim
 
Back
Top