check box values converted for report

[nooner]

I have three check boxes on my form called medium type, you can only choose one of the checkboxes.
If email is checked the value of 1 is entered into the table
If meeting is checked the value of 2 is entered into the table
If phone call is checked the value of 3 is entered into the table.
The problem is that when the I preview the report the number is showing up in the medium type field of the report but I want the name of the medium type to show up, ie if email is selected I dont want the number 1 to show up on the report instead i want email to be stated on the report.I would appreciate any suggestions you may have, thank you in advance.

 

[WayneRyan]

nooner,

Look in the help files for the Iif function.

That will do it for you.

Wayne