number to text

[mejia.j88]

hello all,

i have made a report that includes a particular field called Saw_Number.
In the report, the saw being used appears as a number from 1-8.

saws 7 and 8 are actually a different type of saw, and the report needs to make this clear. i want it to display "Dicer 1" instead of the number 7, and "Dicer 2" instead of the number 8 while keeping the other numbers (1-6)

what is the best way to do this on my report?



thanks, Jorge

[June7]

You can use an IIF statement in textbox ControlSource.

=IIf(Saw_Number = 7, "Dicer 1", IIf(Saw_Number = 8, "Dicer 2", Saw_Number))

[mejia.j88]

when i do that i get #error,
my saw_no field is set to text.

[June7]

Is the fieldname Saw_Number or saw_no?
Does this work better?
=IIf(saw_no = 7, "Dicer 1", IIf(saw_no = 8, "Dicer 2", saw_no))
or
=IIf(saw_no = "7", "Dicer 1", IIf(saw_no = "8", "Dicer 2", saw_no))
or
=IIf([saw_no] = 7, "Dicer 1", IIf([saw_no] = 8, "Dicer 2", [saw_no]))

Make sure the textbox is not named the same as the fieldname to avoid circular reference.

[mejia.j88]

thanks, the last one worked perfectly!