IIF Function Question

R

Robyn H.

I am trying to have a calculation done in a query that would use the IIF
function to determine what the value will be. The expression below is what
I'm using:

NetToClient: IIf(tblTRADES!AccountForCredit<>"BAT" Or
"OUTS",[GrossComm]-([BattenCapKeep]*[TotalShares]),"0")

Access is letting me run the query, but I'm getting an #error message in the
cell every time I run it. Does anyone have any ideas as to what might be
wrong with the expression?

Thanks for your help!
 
Top