Reverse Sequence Number when Presorting in Reverse Order

Exporting expressions and information including exporting data in presort order or import order, and importing information, along with error messages that may apply to this category.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Reverse Sequence Number when Presorting in Reverse Order

Post by Kristen » Wed Apr 20, 2011 12:31 pm

When presorting your database in Reverse Order, the Sequence number is now reversed as well (the first piece in reverse presorted order will be the last record number in your database, reflecting the actual record number of the piece).

Example: If you have 2000 records in your database and you presort in Reverse Order, the first piece to print out will have a Sequence number of 2000 rather than 1.

If you would like to reverse the sequence number so that the first record in reverse order has a Sequence number of 1, do the following:

1) If you are Exporting your file in Presorted Order, in the expression box next to the Sequence field, type in the following Expression:

Code: Select all

ALLT(STR(recno()))
2) If you are printing directly out of AccuZIP and you want the Sequence number to appear on the piece, use this as the expression for the Sequence field in your label template:

Code: Select all

ALLT(STR(recno()))
INSTEAD OF

Code: Select all

TRANSFORM(VAL(sequence))

Post Reply