Multi-column of record report

  • Thread starter Thread starter Barry Tsang
  • Start date Start date
B

Barry Tsang

I'm trying to develop a report with the only leftmost
column as the table's column title and 3 columns next to
it are from the table's records, may be I put it into the
following representation:

page1
fieldname1 record1 record2 record3
fieldname2 record1 record2 record3
fieldname3 record1 record2 record3
fieldname4 record1 record2 record3
fieldname5 record1 record2 record3

page2
fieldname1 record1 record2 record3
fieldname2 record1 record2 record3
fieldname3 record1 record2 record3
fieldname4 record1 record2 record3
fieldname5 record1 record2 record3

I know I can specify Number of Columns in the Page Setup
dialog box and if I set it to 2, each page will be:

fieldname1 record1 fieldname1 record2
fieldname2 record1 fieldname2 record2
fieldname3 record1 fieldname3 record2
fieldname4 record1 fieldname4 record2
fieldname5 record1 fieldname5 record2

the column names are repeating for each record. Is there
any way to get rid of the repeating column names?
 
Barry,
Take a look at Microsoft KnowledgeBase article:
153052 'How to print labels only on the left margin of a report'
 
Back
Top