Changing a numbers sign in a query

J

Joe Cilinceon

What I have is a query on Charges. Now I want to change a sign from + to -
based on the ChgID # in that field.
 
F

fredg

What I have is a query on Charges. Now I want to change a sign from + to -
based on the ChgID # in that field.
Click to expand...

IIf([ChgID]=somecriteria,[Charges] * -1,[Charges])
 
J

Joe Cilinceon

fredg said:
What I have is a query on Charges. Now I want to change a sign from
+ to - based on the ChgID # in that field.
Click to expand...

IIf([ChgID]=somecriteria,[Charges] * -1,[Charges])
Click to expand...

Thanks fredg that worked good. I've had brain lock today and for some reason
I just couldn't figure out how to do it, simple as it is.
 
Top