Change data in a calculated field?

[Kevin]

Is there a way to allow users to alter/enter data in a calculated field from
a query? I'm creating an estimating database in which unit cost of an item
from our own product library (Combo box based on a table) is calculated. We
also need to have the option to enter an amount of an outsourced product that
is priced on a job by job basis, so I need to build in the flexibility to
enter the amount quoted to us from our supplier.

Is this even possible? Thank you for any suggestions!

 

[Ken Snell [MVP]]

No, a calculated field cannot be edited/changed by a user. Set up your
table/query so that you have fields that allow entry, and then the
calculated field can use those fields to calculate its value.