Bakken Software Services

Specializing in the Pick / MultiValue Database & Environments

Home

Consulting

Education

Education Overview

Education - Schedule

Introduction to Pick / MV

Database Retrieval - Fund

Database Retrieval - Adv

Basic Programming

Enrollment

RPL

Tips & Tricks

Join Our Mailing List

Contact Us

Tips & Tricks - Invisible Dictionary Word
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