update table with info from subform

J

Jenny

Hi There

I have a subform which calculates totals, but it does not store them in the
table on which the subform is based.

I'm sure the answer is easy as to why this is not happening, but I cannot
figure it out!!

All other information entered on the subform gets stored in the table - just
not the calculations.

Please can anyone help me.

Thanks a million
Jenny
 
V

Vincent Johns

Jenny said:
Hi There

I have a subform which calculates totals, but it does not store them in the
table on which the subform is based.

I'm sure the answer is easy as to why this is not happening, but I cannot
figure it out!!

All other information entered on the subform gets stored in the table - just
not the calculations.

Please can anyone help me.

Thanks a million
Jenny
Click to expand...

Although it's possible to store the results of calculations into a
Table, doing so is usually considered poor practice for various reasons...

- The calculated values would have to be replaced any time the
underlying data change
- They occupy space in the database
- It's easy and cheap to redo the calculations, using a Query, any
time you need to do so

That's not to say there is never a reason to store the results of
calculations (for example, with complex calculations, you might be able
to save some CPU time by storing, but at the expense of having a Table
that would be harder to maintain than it need be).

Assuming you still really want to do something that I think you should
avoid, you might post the SQL that you're trying to use to update the
Tables.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Top