Occasionally you may have the need to produce an Access report where you are breaking and paging on a particular field of information. In our example below, we are breaking and paging on the saleperson's name. As the salesperson's name will be inserted in the heading as it changes, it really would be redundant to also have a column of data on the report for the salesperson's name.
An INVISIBLE dictionary word will allow you to break-on the field, but will NOT create a column of data for that particular field on the report.
Note: The salesperson's name exists in attribute 10 of the CUST file.
Access Statement
SORT CUST BY SMAN BREAK-ON SMAN "'BP'" CUST.NAME TOTAL A/R.BAL HEADING " 'C' REPORT OF 'B' PAGE 'PLL'"
Output
REPORT FOR ART BYE PAGE 1
CUST NAME A/R.BAL AB100 ABC COMPANY 5011.20 LI123 LITTLE TOT DAY CARE 0.00 CD400 C. D. EDWARDS AND CO 531.75
Atb.
0
SMAN
SMAN
1
S
S
2
10
10
3
\
Alternate column heading
4
5
6
7
8
9
U
Justification
10
0
Length for output
An invisible dictionary word requires a backslash as the S/Name, a justification of U and a Max or length of zero.
Bakken Software Services ... The Obvious Pick 1-708-998-4925