Changing a number to text in a query

[Garridon]

This is probably something really simple, but I'm not quite sure how to do it.<br><br>I have two fields, both yes and no, that return a numerical value (1=Yes and 2=No).&nbsp;&nbsp;I'd like to do a report where it prints a yes or no instead of the number.&nbsp;&nbsp;How do I do this?&nbsp;&nbsp;I have a select query set up for the report.<br><br>Thanks!<br><br><br> <p>Linda Adams<br><a href=mailto:Garridon@aol.com>Garridon@aol.com</a><br><a href=

http://www.geocities.com/hallona_2000>Linda

Adams Online</a><br>I'm a professional writer, published internationally.

 

[DougP]

Make a new field it cannot be the same name as the Yes/No field<br>Put this in the Control Source<br>=IIf([FieldName]=-1,&quot;Yes&quot;,&quot;No&quot

 

[elizabeth]

If you want it to show as Yes or No all the time, you can change it in the table itself. In design mode, click on the YesNo field and select Yes/No from the pulldown on the &quot;General&quot; tab below.

 

[Garridon]

Thanks for your help!&nbsp;&nbsp;I'll give this a try.<br><br> <p>Linda Adams<br><a href=mailto:Garridon@aol.com>Garridon@aol.com</a><br><a href=

http://www.geocities.com/hallona_2000>Linda

Adams Online</a><br>I'm a professional writer, published internationally.