Change value from query when displayed in report text box

[RogerC]

I have a report that uses a query to display all records that contain the text 'Blue' or 'Green' in the table's column named 'Color'. On the report, I need to 'convert' the text that is shown in the 'Color' text box control to this:

If the record contained 'Blue', show 'Yes' in the text box.
If the record contained 'Green', do not show anything (blank text box).

Can this be done?

 

[Joe4]

Re: Change value from query when displayed in report text bo

Create it as a calculated field in your query (using the IIF statement). Then it is just a matter of selecting that calculated field to display in your report.

 

[Joe4]

Re: Change value from query when displayed in report text bo

In your IIF statement, simply return nothing, which is two double quotes with nothing in-between. Something like:

IIF(Condition, "Yes", "")

 

[RogerC]

Re: Change value from query when displayed in report text bo

Thanks jimisky! That worked perfectly!