Update query Help

[Guest]

I want to change the premuims payed by the members in the whole table from
one amount to the other EG: R72.00 to R85.00 but each premuim is divided up
in to brokers fee, admin fee ETC. I did test this on a mock data base I used
[PAYMENTS]![MEMEBRS]*1.1 To increase it by 10 % but i dont know how to tell
it to change from 72 to 85 and how to see if it effects the break down of
fees?????????

Thank You
george

 

[Jeff Boyce]

George

Are you saying that every row that has "72" should have that replaced with
"85"?

If so, you could first build a select query that finds all the "72"s, then
change it to an update query that updates that field to "85".

Or am I missing something...