Records displayed accross page not on new page

[Brad]

Thanks for taking the time to read my question.

I have to make a report that has the records displaying across the page
(left to right) instead of on a new page.

So I'll need to have my row headers in my first column on the left side of
the page, then the data in the next 3 columns. Then a new page will start
with the same format, but the data will be the next 3 records.

Ex:

(Page header here)

(Detail)
Category Result 1 Result 2 Result 3
pH 7 6.2 6.96
Iron 92 92 91.9
Mn 34.2 33.8 31.1

(Page footer here)

I hope this makes sense.

Thanks,

Brad

 

[Duane Hookom]

Have you considered creating a crosstab query to base your report on? Will
the "next 3 records" be Results 4-6?

There are some crosstab report samples at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

There is a KB article "How to Show Only Labels in the First Column of a
Report" at
http://support.microsoft.com/kb/208491/en-us

 

[Brad]

Thanks Duane,

I'll look into both.

have a great day,

Brad