I have a report that has week numbers within each week are cranes that have a delivery date, I have identified that all cranes go into storage has a week "0"
Within the report I want to replace the "0" with some text "STORE", I have tried VBA using an if statement, conditioning format just cant get it to work, the "0" is a number field, any ideas.
Within the report I want to replace the "0" with some text "STORE", I have tried VBA using an if statement, conditioning format just cant get it to work, the "0" is a number field, any ideas.