Calculated expressions in a table

[Guest]

Currently I have an unbound text box serving as a calculated expression. Is
it possible to store the result from the calculation to a field in a table?

Example:

Subtotal (unbound): $10.00
Shipping (bound): $10.00
Total (unbound): $20.00 [is it possible to save this result to a
table?]

Thanks!

 

[Nick Coe \(UK\)]

Yes, but it's regarded as very bad practice. The reults of
calculations should always be shown on the fly so that they
reflect the latest source elements.

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store
http://www.mrcomputersltd.com/ Repairs Upgrades

In SeanK6876 typed:

 

[Guest]

If you search this discussion group about a similar question, you'll see that
there is always one answer.
It's not recomanded to store a calculated field in a table, you can always
get the resault using a query

Select Subtotal,Shipping , Subtotal + Shipping As TotalField From TableName

Storing the resault in a table will require maintnance and can cause errors,
for example, if a user will update the table directly, he'll have to remember
updating the calculated field