Report to change field value in report if it equals this?

[caniread]

I have a report that lists scrap reasons. How would I change the reason listed in the report without changing the query? I just need the report to change the value in the report, example when "X" change value to "Y" otherwise stay the same value as in the field name "WASTE". Anyone one know how to write this in the control expression or VBA?



Thank you for the help,

Isaac

[Micron]

You'd use an IIF expression in a calculated (not bound) control that references the control(s) providing the primary and alternate data. I can't really even guess what that expression might look like based on your limited description of the situation except to say that x and y would be the control names.

[caniread]

Here is what I came up with using your comments. When true it isn't putting in "SURFACE DEFECTS", instead it says 0. Is there something I am missing?

=IIf([WASTE_REASON]="CHOPPING",[WASTE_REASON]="SURFACE DEFECTS",[WASTE_REASON])

OK, I figured it out. Thank you for pointing me in the right direction.

=IIf([WASTE_REASON]="CHOPPING","SURFACE DEFECTS",[WASTE_REASON])