print seven numbers across a report

[Rick A]

I need to print seven numbers across a report on each page of the report. I
have more than seven values so this report needs to span pages.

I have the following data:
EventID TitleID ArmBandNumber
1 1 123
1 1 124
1 1 125
1 1 126
1 1 127
1 1 128
1 1 129
1 1 120
1 2 223
1 2 224
etc...

The report needs to print by EventID by TitleID seven numbers across the top
for page one and the next seven across the top of page two, etc for as many
pages as needed for the EventID and TitleID.

How can I do this? I've tried crosstab queries, no luck. I've tried
subforms tied to a multiple column report, no luck. There has to be a way to
do this and I'm just overlooking it.

Thanks,

Rick

 

[Duane Hookom]

There is a crosstab sample solution at
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4 that should
work for you. Apparently you would want a page break between each "level" in
the report.