Report with Multiple Columns and Freeze Row Headers

[blimp]

I need to create a report in Access 2000 that prints multiple columns by
group and prints a row header in every page. The output is similar to a
pivot table view. Tried creating a subreport 1 for the row headers and a
subreport 2 for the multiple columns but subreport 2 only displays 1st
column. Thanks in advance for the help.
-Benny

page 1
Location1 Location1 Location1
Sample1 Sample2 Sample3

Analyte Unit Result Flag Result Flag Result Flag
-------------------------------------------------------------------
Lead mg/kg 3.5 U 7.7 J 350
Zinc mg/kg 35 U 711 3500
....

page 2
Location2 Location2 Location2
Sample11 Sample22 Sample39

Analyte Unit Result Flag Result Flag Result Flag

 

[Steve]

Look at Crosstab query in the Help file. You can then make a report from the
crosstab query.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[blimp]

Steve,

Crosstab does not allow me to
_create multiple column headers (I need 8 column headers in grouped by 1
column)
_create 3 row-column intersections (I need to control each value so I can
not concatenate the 3 fields)

Thanks,
Benny

Look at Crosstab query in the Help file. You can then make a report from the
crosstab query.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Steve]

Hi Benny,

It appears to me that you could create your example with a crosstab query.
Rows would be Analyte and Unit concatenated, Columns would be Location with
Sample below it and the Value would be Result. Flag would not be in the
crosstab query. Flag would be an unbound textbox in your report and in the
control source, flag would be calculated based on Result.

The only difficult thing would be to get Location and Sample above each
column.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Steve,

Crosstab does not allow me to
_create multiple column headers (I need 8 column headers in grouped by 1
column)
_create 3 row-column intersections (I need to control each value so I can
not concatenate the 3 fields)

Thanks,
Benny