Hi,

How can I save a calculated field into a table, I wrote the expression in the control source. Let's say I want to store it in "TotalPrice" field. How can I do it? Thanks!

I always feel this is a bad idea. I myself would instead store the "Quantity" and the "Price at the time". Then when I need "TotalPrice", I would dynamically calculate "Quantity" * "Price at the time" to get my result. The reason being, if the quantity should change for any reason or any other value that could effect the "TotalPrice", the stored value in your table for "TotalPrice" (as you suggest) will not reflect an accurate value.

HTH
RDH

[This message has been edited by R. Hicks (edited 09-07-2001).]