Calculation?

  • Thread starter Thread starter Sharron
  • Start date Start date
S

Sharron

Hi, I would like to ask anyone, how I would enter a
calculation to update query, that adds 8.25% to all
records in a particular field that are above $200.00
 
Set up your update query. In 'Update To' put [yourfield]
*1.0825 and in the criteria put >200

Hope that helps.
 
-----Original Message-----
Set up your update query. In 'Update To' put [yourfield]
*1.0825 and in the criteria put >200

Hope that helps.
-----Original Message-----
Hi, I would like to ask anyone, how I would enter a
calculation to update query, that adds 8.25% to all
records in a particular field that are above $200.00
.
Click to expand...
.
Click to expand...
 
This is not working, I must be doing it wrong. I am
putting in [myfield] * 1.0825 in the field box, and >200.
I get a invalid syntax message. Thank you in advance.
-----Original Message-----
Set up your update query. In 'Update To' put [yourfield]
*1.0825 and in the criteria put >200

Hope that helps.
-----Original Message-----
Hi, I would like to ask anyone, how I would enter a
calculation to update query, that adds 8.25% to all
records in a particular field that are above $200.00
.
Click to expand...
.
Click to expand...
 
This is not working, I must be doing it wrong. I am
putting in [myfield] * 1.0825 in the field box, and >200.
I get a invalid syntax message. Thank you in advance.
-----Original Message-----
Set up your update query. In 'Update To' put [yourfield]
*1.0825 and in the criteria put >200

Hope that helps.
Click to expand...
Click to expand...

Please post the SQL of your query. I think what was suggested was that
you put
200
Click to expand...

on the Criteria line, and

[myfield] * 1.0825

on the Update To line, using of course your own field name in place of
myfield. Is this what you're doing?
 
Back
Top