Adding Based on Value

[Sola]

Hi. If someone could point me in the right direction, that would be great. Right now, I am not even sure if I should be trying to create an expression in Design View or if I should be trying Visual Basic.

I have a report query that shows each transaction for medications. There is a TransactionType field and a Quantity field. The values in the TransactionType field are "Prescribed" and "Stocked."

How can I get the # in the Quantity field to be set as positive or negative, based on the TransactionType, without the users having to key it (+/-) in themselves?

It would look like:
Qty TransType
-10 Prescribed
10 Stocked

 

[Sola]

Well, asking seems to have jarred my brain loose.

Quantity: IIf([TransType]="Prescribed",-[Qty],[Qty])

 

[Sola]

Can anyone tell me how to mark a thread solved?

 

[The_Doc_Man]

You just did.