Multiple column report help

S

Suzie

I want to make a multiple column report. I have a table where each record
contains 20 fields. I want to display the records in a report with each
record in one column, having 6 records per page. I have been able to get
this part set up, but now I want to have labels on the left side of the page
(that only print once per page) that identify the name of each field. Can
anyone help me please? TIA
 
S

Steve

I have been searching the discussion group for this same problem. I have used
the code from the KB article that Duane referenced and now have a report that
is setup with a column width of 2".

I seem a bit confused, I am trying to have a report header that is across
the whole page but no matter what I do with the column width in the page
setup dialog I cannot get the correct format. If I set up 4 columns 2" wide
with the "same as detail" unchecked and then have a header centered on the
page (Letter in landscape) I end up with 4 columns of labels not the text
info from my query. If I do not use a header and have the report width at 2"
I get one column of labels and then 3 columns of data as I need.

Am I missing something here is there really a way to have the report header
wider than the detail section or does the bit of code that I have used from
the KB article not allow me to use a header that is more than the width of
the columns.

Thanks in advance

Steve
 
Top