I have a report that I want a product code to appear on, however I need to supress the first 7 characters and then the last 5 characters, leaving the remaing characters in the middle to appear.

 

If I use the below it only joins the formulas together not work together to give the desired result.

 

right ({Product.ProductCode},Len({Product.ProductCode})-7) + Left ({Product.ProductCode},Len({Product.ProductCode})-5)

 

Can anyone help?

 

Thank you