Yes/No column question

[trish.martins1984]

I created a yes/no column on my table. On the report I want them to say something other than yes or no.

How do I go about doing that?

Thank you!

 

[odin1701]

IIf([yes/no Field Name] = Yes, "Return if Yes", "Return if No")\

Look up the IIf function in help.

 

[Rich]

There are no quotes required surrounding a Yes/No field

 

[odin1701]

There are no quotes required surrounding a Yes/No field

Right...too used to using that function with strings.

 

[trish.martins1984]

and i put this formula inside the properties of the yes/no field?

 

[trish.martins1984]

I still need help with this.

I tried it and I've gota be doing something wrong.

Thank you

 

[DJkarl]

I still need help with this.

I tried it and I've gota be doing something wrong.

Thank you

On the report you are trying to make you would replace the ControlSource for the Yes/No field with the formula

So
=[Yes/NoFieldName]

would become

=IIf([Yes/NoFieldName]=Yes,"YesValue","NoValue")