Could it be that the field you are using in the IF statement is not numeric, so its really not doing what you want it to do? I’m scratching my head about the same kind of IF statement I’ve been attempting… Do I need to make both my compare fields Numeric inorder to get the result I’m seeking? For example, is fld A less than zero? So fld A should be numeric, correct?
When you use the MATH command on fields do they both have to be numeric too?
Thanks, Mary.
