Fields on the Report 1

[Howard2002]

In my report design there is a field called Sex. In my table the field has either a '1' for Male or '2' for Female. my question is how do I write code behind the textSex field on the report to display 'Male' or 'Female' or 'Unknown'(if there is no entry in the table field).

 

[mm0000]

This code in testsex should do it :

iif(sex=1,'Male',iif(sex=2,'Female','Unknown'))

 

[mm0000]

Included quotes since sex was a character field:

iif(sex='1','Male',iif(sex='2','Female','Unknown'))

 

[Howard2002]

Thanks, I had tried the iif but did not have the syntax right. I am so thankfull for Tek_Tips because the VFP books just do not explain this stuff completely and give good examples,