Positive to Negative

[greek-autumn]

I am a novice database builder only because I had to become one for work. So please bare with me in my lack of knowledge. I'm sure someone has run into this before so I'm hoping someone can help me out.

I am trying to convert a currency field from a positive number to a negative number, but the determinate on if it needs to change to a negative is based on the entry in another field. I have a field called DocBal and another field called DocType. If the DocType is "AD" then the DocBal value needs to be negative. If the DocType is anything else then the DocBal needs to stay positive.

I've tried an IIF statement, but it isn't working.

Any help would be greatly appreciated.

Thanks!

[Bob Fitz]

You could create a new text box in your form and set its Control Source property to:
= IIf([DocType]="AD",-1*[DocBal],[DocBal])

[greek-autumn]

Thanks Bob!

This worked like a dream. I thought I had tried every combination of the formula that I could to make it work, but I guess not.

Thanks again!

[Bob Fitz]

Alternatively, you could use the given expression in the forms query.