User Support Forum

I need help with the syntax when writting my custom reports. Seems I'm always screwing up the ifs/ands/or commands. What manual or For Dummies book would you recommend to help me with this language?

For example: my code of-
IIF((status_desc = "Member" ) OR (status_desc = "Inactive member"), "Member", "Not a member")
is always coming back False (Not a member).
I'm not getting any members. What's a better way to state this? It veryifies clean.

This is Visual FoxPro. The example you are showing should work, if you've spelled and cased the text correctly. To prevent loss of functionality when someone changes the case of the values you could do this:
If you need to be more exact this syntax would be used (the double equal means they need to exactly match:

Thanks, I used your syntax and now it works fine.