Access Query Help

[sandingdude]

I have a database with 5 Fields with Yes/No Data Type. I want to run a query that replaces a True with a Yes and False with a No. What is the criteria for this? I am posting these results in a database and I need the Results to say YES instead of TRUE.

Thanks guys,

 

[PaulBricker]

MyResults:IIf([FieldName]=-1,"Yes","No&quot

Put this in a new column in your query and change the field name to one of your fields.

Paul

 

[sandingdude]

Paul,

What should I call my new column?

Thanks.

Dave

 

[sandingdude]

Paul,

I figured it out. Nevermind, thanks for your help.

Dave