Multi-column of record report

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?
 
F

Fredg

Barry,
Take a look at Microsoft KnowledgeBase article:
153052 'How to print labels only on the left margin of a report'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help to know How to Multiply results in a report 2
How do I repeat other column data if one column expands to another page? 0
Grouping records on the same line of a report 4
Access Vertical Reports 4
Report 1 record twice 6
Report using Select Case 5
Report format 2
One to many Relationship in one record 6

Top