Calculated Field in Query

[Dickx]

When I change a value in a non calculated field in a table based query, the value along with the calculated field is changed. In the table, only the modified value, not the calculated field is changed. What can I do to get both fields to change in the table.

 

[sfreeman]

Post the SQL

 

[PHV]

Anyway it's often a bad idea to store calculated or derived values in a database as you may retrieve the accurate value by doing the calculation in a query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KenReay]

By Definition if it is a calculated field (eg Result:[Price]*[Qty]) or in SQL SELECT ... Price * Qty As Result,... then it does not physically exist in the tabel and thus cannot / will not be updated. This is as it should be.

Regards

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

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

UK