Crosstab report

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I created a report based on a crosstab query that is
wider than the page (landscape) and several pages long.
Is there a way to have the row "headings" repeat on
subsequent pages for the columns that exceed the width of
page one? (Access 2002)

Any help is appreciated.
 
In Access 2000, you select the controls you want repeated on each page, and
put them on the "Page Header" section.

You might have to turn on Page headers and footers, or they may be height=0.
I don't know if 2002 is the same, but i imagine this would still be a good
place to look.

<Barney />
 
Thanks Barney. I have column headings in the page header
section and they work fine. I am having trouble getting
the first 3 columns (row headings [?]) to repeat on
multiple pages. For instance:

itemA itemB itemC itemD.....
parameter1
date1
date2
date3
parameter2
date1
date2
date3
parameter3
 
You might want to review the crosstab report downloads from
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

--
Duane Hookom
MS Access MVP


Bill said:
Thanks Barney. I have column headings in the page header
section and they work fine. I am having trouble getting
the first 3 columns (row headings [?]) to repeat on
multiple pages. For instance:

itemA itemB itemC itemD.....
parameter1
date1
date2
date3
parameter2
date1
date2
date3
parameter3
.
.
.

In this setup, I would like the parameters and dates to
appear on all the pages. They appear on the first page
but not on later pages where the number of items exceeds
the page width. Thanks.


-----Original Message-----
In Access 2000, you select the controls you want repeated on each page, and
put them on the "Page Header" section.

You might have to turn on Page headers and footers, or they may be height=0.
I don't know if 2002 is the same, but i imagine this would still be a good
place to look.

<Barney />





.
Click to expand...
Click to expand...
 
Back
Top