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
> 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 Wyse - 01 Nov 2004 11:08 GMT
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
> Jim:
>
[quoted text clipped - 19 lines]
> > back to the table for me.
> > Someone must know what I'm doing wrong?!