I have a field that contains two types of information; either a number (usually 111) or the word "RETEST". In my report I am trying to make the field for this print a "$" if it is a number and the word "RETEST" if it is not a number. I am using an unbound text box with the following code in the control source:
=IIf([Payment Amount]>1,"$" & [Payment Amount],"RETEST")
This works in as much that it puts the "$" in front of the number as requested, but for everything that is not a number, it says, "#type!". Any ideas on how to make this work?
Thanks!