access.sort-label
Produces formatted and sorted labels.
Syntax
sort-label file.reference {itemlist} {sellist} {seqlist} {outlist} {modlist} {(options)}
Description
produces one or more columns of output in order of the specified sort-key(s).
Outputs formatted labels or reports in columnar format from the specified file.reference, sequenced by one or more sort-key(s).
After pressing <return> to submit the Access sentence for processing, a '?' prompt appears. This prompt is to supply the label output parameters:
columns The number of labels across page.
rows Number of print lines on each label.
skip Number of lines (vertically) between labels.
indent The number of spaces to indent from left the margin.
size The number of print positions per label.
space The number of spaces (horizontally) between labels.
c Compresses null values.
Each parameter must be separated by a comma.
If the 'indent' parameter is not zero, this command prompts for entry of the 'header' text for each print line requested. If any text is entered at any of these prompts, that text will appear before the corresponding print line on the left-most (1st) column only. Pressing <return> at any of these prompts indicates a null header.
Options
* see 'options: Access'.
Example
:sort-label entity by zip contact company address csz (cip
?2,4,1,0,30,2,c
The label parameters shown define the output as having 2 labels across, 4 lines
each (contact, company, address & csz), skip 1 line, indent 0 (zero -
assumes labels are mounted at first print position), 30 print positions each
(longer strings are truncated to 30, in this case), space over 2 to the right
between each label, and 'c' for 'compress' nulls
(don't allow blank lines within the label).
See Also
User Comments
What do you think?
Share your experience or ask a question by using the form below.
Login to leave your comments.