Hi Everyone:
I have this code in my report in the Print When section.

*// code
IIF(Between(creport.type,1,2),"L",IIF(creport.type=5,"M",IIF(Between(creport.type,6,9),"D","")))
I want the report to display "L","M" or "D" depending on the value in creport.type.

However, when I run the report I am getting nothing, The field is blank. It should not be blank, becaue I know that there are two record in my cursor (creport). The values of type in creport are 1 and 5. Can anyone tell me why I am not getting the correct result.
Thanks
MA