Code: Select all
IIf([Type] Like "Buy*",([Quantity]>=0 Or [Quantity] Is Null) And ([QtyFilled]>=0 Or [QtyFilled] Is Null),([Quantity]<=0 Or [Quantity] Is Null) And ([QtyFilled]<=0 Or [QtyFilled] Is Null))
Code: Select all
IIf([Type] Like "Buy*",([Quantity]>=0 Or [Quantity] Is Null) And ([QtyFilled]>=0 Or [QtyFilled] Is Null),([Quantity]<=0 Or [Quantity] Is Null) And ([QtyFilled]<=0 Or [QtyFilled] Is Null))