Changing a phone number to a "Y"

[Ptrif]

I have a report that shows a name and a phone number. What i need to know is if there is a phone number I would like it to display a "Y" and if the field is blank and there is no phone number i would like it to display a "N". How would i go about doing this?

Any help is appreciated.


Thanks

Paul

 

[jebry]

Hi!

In the controlsource of the text box use this:

=IIf(IsNull([YourTelePhonField]) = True, "N", "Y")

hth


Jeff Bridgham
bridgham@purdue.edu