I sent this yesterday.
I have a shipping label used for Bill of Lading. I want to have the label show the number of pieces as 1 of 2, 2 of 2 then reset based on the Control#. The label is based on the BOLRows table with information pulled from the BOLHeader table. The pieces are in the BOLRows table. I tried the Count function of the DBcalc but it did not reset on the field Control#. Jim I have also tried this using a view based on the BOLHeader and BOLRows with the same result. I have the total number of pieces in the header so that is not a problem. I just need to have a reset on the field Control# and then figure how to do the 1 of 2, 2 of 2 etc.
