J Joe Cilinceon Nov 6, 2005 #1 What I have is a query on Charges. Now I want to change a sign from + to - based on the ChgID # in that field.
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 Nov 6, 2005 #2 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])
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 Nov 6, 2005 #3 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.
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.
