To many pages

[Franknstuff]

I have a location and a part. There can be 300 locations for the same part.
When I created a report it listed all the locations down the sheet. Is there a way to combine the 300 locations into a group on the report so that I would'nt need 50 sheets of paper?

 

[Franknstuff]

Almost

I like it, but I really need the locations to display across in order.

Bolt 4/40:
Location:
B1,B2,B3.. \
B6,B7,B8.. | This kind of grouping.
B290,B291,... /
Nut 3/16:
Location:
N5,N6,N7
N8,N9,N10

I was hoping that access allows this in reports.

 

[Franknstuff]

Nice

Thanks, you save a few trees...

 

[Franknstuff]

Sorry

I think I jumped the gun.. I got the subreport to go horizonal , but when I place it in the report the subreports format get set to the reports format. I don't know if this makes any since or not.

 

[Franknstuff]

Cool

It seems that the AUTO NAME did the trick, now I know why you could'nt
understand why it didn't work for me THANKS ALOT.......