Calculation?

[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

 

[sam]

Set up your update query. In 'Update To' put [yourfield]
*1.0825 and in the criteria put >200

Hope that helps.

 

[Thank You..]

-----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
.

.

 

[Guest]

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
.

.

 

[John Vinson]

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.

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

200

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?