Calc Control in an update query

  • Thread starter Thread starter SAC
  • Start date Start date
S

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.
 
SAC said:
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
Click to expand...

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?
Click to expand...

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;
 
Back
Top