Hi there,
question:
a status field gives an outpuit of 1, 2, 3, or 4
if it gives an output of 1 then I want to show the text 'any tekst'
if it gives an output of 2 then I want to give the tekst 'any other tekst'
I tried the IF(1,'text', 'anytext') for the status field man and wife and that works BUT I have 4 different status possibilities (1,2,3 or 4)
can anybody help me
STEVEN