Thanks to the people who helped me with my IF statement question last night.
Now I need to carry it one step further to a compound 'IF' statement. Again,
can't find much information in the manuals --
Several people sent me "IF (Adopted=1, 'Y', 'N') AS Adopted FROM Animal" and it
works great. Now I want my report to show the English Language meaning for a
field ('Location' in a table called 'Animal') that contains numeric values.
In other languages it would be something like this (a compound if statement):
IF Location=1
MOVE 'Downstairs Cat Room' to Location
ELSE IF Location=2
MOVE 'Kitten Room' to Location
ELSE IF Location=3
MOVE 'Quarantine ' to Location
ELSE MOVE 'Unknown' to Location
END IF
In other words, I want to test for the comparison being true, and if it isn't
true I want to test it again for another value... I couldn't find any
information about this construct in the manuals or past list messages. I also
tried using the 'CASE .. WHEN .. THEN .. END' but couldn't figure out the
syntax errors I was getting.
Thanks again for your help and support-
Sue
