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 :rolleyes: need 50 sheets of paper?

Make a subreport that has multiple columns.

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.

If you look at making colums you will see that you have the option of down then across or across then down.

Thanks, you save a few trees...

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. :o

I am not sure what you did wrong but it does work so try again. I always create the subreport and save it. Then I add the subreport to the main report. If you are using A2K and you haven't upgraded to at least service pack 2, you may be running into the "Name AutoCorrect" bug. If that is the case, go to Tools/Options and turn off all the Name AutoCorrect options OR apply the latest Office service pack.

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.......