Hi I am trying to find the syntax to value to another "word" , but the statement below doesn't seem work when the value is letters ? =SWITCH(Fields!Product_Type.Value=4072, "WEG Motor",Fields!Product_Type.Value=4070,"WEG Drive",Fields!Product_Type.Value=4071,"WEG Softstarter", Fields!Product_Type.Value=HQ,"Freight") Kiwi_Wizz

Hi Kiwi_wizz, Try placing double quotes around the string - e.g. "HQ". Boyan Penev --- http://www.bp-msbi.com

Hi Boyan Penev Unfortunely it #errors when I run the report ? the other values come out correctly.Kiwi_Wizz

Ok I put " " around all the value and it works perfectly Thank youKiwi_Wizz