Update one field from another field in same table

[Guest]

I've got a table that describes a product we sell. One of the fields
contains our cost for the product. Another field has our selling price. If
we buy it for a $1.00, I want to use a percentage markup to fill in the
selling price column automatically. What expression, if any, can I use to do
this. I realize I could use a query, but I would like the sell price to be
contingent, all the time, on the cost price.

Thanks for your help.

 

[Guest]

What is stopping you from using a query?

sellprice: [costprice]*1.25

 

[Joseph Meehan]

I've got a table that describes a product we sell. One of the fields
contains our cost for the product. Another field has our selling
price. If we buy it for a $1.00, I want to use a percentage markup
to fill in the selling price column automatically. What expression,
if any, can I use to do this. I realize I could use a query, but I
would like the sell price to be contingent, all the time, on the cost
price.

Thanks for your help.

Tables are only for storing data. They don't do calculations.

Queries do calculations. They could even update a table with the
results, but this is not recommended. Access can recompute the results in a
query faster than it can look them up in a table and it does not use up
storage space in the process. It also avoids the problem of what happens of
one of the pieces of data changes and no one has run the update so your
calculated result would be out of date.

 

[Guest]

Tables are only for storing data. They don't do calculations.

Queries do calculations. They could even update a table with the
results, but this is not recommended. Access can recompute the results in a
query faster than it can look them up in a table and it does not use up
storage space in the process. It also avoids the problem of what happens of
one of the pieces of data changes and no one has run the update so your
calculated result would be out of date.

Joseph:
Thanks for your help.