Convert numerical value to Yes-No

[jereece]

I have a report that is based on a query using Linked Tables to an SQL database. One of my fields [MR] returns -1 for Yes and 0 for No. I want my report to show Yes and No not -1 and 0. How can I make the report do this?

Thanks,
Jim

 

[pbaldy]

Try

=IIf([MR] = True, "Yes", "No")

 

[jereece]

Just to clarify, would this go into the Control Source field on the Property Sheet for the field?

 

[pbaldy]

It would be the control source of a textbox on the report. You could also create a calculated field in the query underlying the report:

NewFieldName: IIf([MR] = True, "Yes", "No")

and then just have a textbox with NewFieldName as the control source.

 

[jereece]

Great. Thanks for the info.

Jim