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