Try using a temp table and adding the count to the rows. My temp table
would have two extra integer columns to indicate PieceNum and
TotalPieces. Project the temp table from the real table and add the two
extra columns to it, then copy the label over to the new temp table.
Albert
Jim Belisle wrote:
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
