Change Page On Change of Product Code

Hi, Hoping to get report passed off today but one problem i have with the re format of the report requested.

I have been asked to put product code in the Pahe Header, But i need the page to change when this changes.

IE: We have prod Code Wel008-110KSI and it runs 4 coils per shift on average, but on the odd time we have a shift that changes over to another Product Code half way through the sift, so would need to have the page change and and display the coils run on that shift.

Thanks all for your fantastic help so far this has been completely great.

Regards

Steve
[614 byte] By [snoopsterg] at [2007-11-20 11:48:29]