Multiple Column Report

[Guest]

I was wondering if anyone knew how to make a multi-column report that would
show a fields label off to the left then have the data for that field in the
columns without repeating the label? Similar to how it is done when you do
not use columns and the label is in the PageHeader...

Example
(label) Sample1 Sample2
Result1 2.5 3.2
Result2 12.5 16.9

Thanks for your help!!

 

[PC Datasheet]

You need to use a crosstab query as the recordsource for your report. Set
the Columns to Sample, Rows to Result and Values to the field with your
result numbers.

 

[Marshall Barton]

I was wondering if anyone knew how to make a multi-column report that would
show a fields label off to the left then have the data for that field in the
columns without repeating the label? Similar to how it is done when you do
not use columns and the label is in the PageHeader...

Example
(label) Sample1 Sample2
Result1 2.5 3.2
Result2 12.5 16.9

Here's a KB article that demonstrates that effect:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208491

 

[Guest]

That looks like it will work Marsh!!! Thank you!!! I have tried using the
crosstab but since I don't know how many samples there will be the crosstab
report gets a little hairy. I have the Access Developers handbook by Getz
Litwin and Gilbert that has a routine in there for handling that problem but
it has to have a fixed number of columns to begin with and that does not seem
to be right either.

So thanks for you help to PC Datasheet!!

mcgj