A program to recognize and reward our most engaged community members
Is is possible to output a NULL value in an IF statement.
If([Unearned Deferred Costs1]>0 .OR. [Unearned Deferred Fees1]>0,"Deferral - Deferral 1",'') creates a blank which is getting picked up in a Count function.
Janet
Unfortunately the IF expression did not like 1/0.
Sorry, I should have suggested:
str(1/0)
because you are outputting a character field.
try using 1/0
That is exactly what I needed. Thanks Chris!
