Calc Control in an update query

[SAC]

Acc 2000

I'm trying to use a calculated control in an update query.

I have PriceEa in a column, then I have an alias such as NewPrice: PriceEa *
1.10

Then I would like to update PriceEa with NewPrice, but it keeps asking me
for the NewPrice Parameter.

Any ideas?

Thanks.

 

[Dirk Goldgar]

Acc 2000

I'm trying to use a calculated control in an update query.

I have PriceEa in a column, then I have an alias such as NewPrice:
PriceEa *
1.10

Please pardon a terminological quibble: that would be a calculated
field, not a calculated control.

Then I would like to update PriceEa with NewPrice, but it keeps
asking me for the NewPrice Parameter.

Any ideas?

Just use the expression itself, not the caculated field, in the "Update
To:" row of the query design grid:

Update To: [PriceEa] * 1.10

You really don't need to show the calculated NewPrice field at all. In
SQL, the query would look like this:

UPDATE <your table name>
SET PriceEa = PriceEa * 1.10;