code is a numerical field (1-4) used for payment type such as cash, check, AP, type is a 1 character string field that is used to indicate if a payment adjustment applies. normally this field is blank, if an adjustment applies it is A

 

I want to select all code equals 3 and type is not equal to 'A' records - when I do, I get no records if I select on just code equals 3 it works for all types, if I select only  type equals A I get all of A types, if I select on type equals '' or not equal to A I get nothing

 

Any idea what I'm doing wrong?  I'm sure it's something simple!

 

Thanks in advance,

Cyber-guys

 

I had already tried {paymentdetails.type}<>'A') with no luck

 

isnull({paymentdetails.type}) is what did the trick!

 

Thanks again,

Cyber-guys