Create three columns of data from the same field

[ChuckW]

Hi,

I have a report that lists the names of people who have been to our store in
the past six months. I need to send this out to someone. It take about
three pages and only has one column (Customer Name). I would like to somehow
create a one page report that lists this one column three or four times. So
there would be three rows. The first row would be customers 1-40, the second
would be clients 41-80 and the third would be clients 81 + the remaining
clients. Is there a way to do this?

Thanks,

 

[fredg]

Hi,

I have a report that lists the names of people who have been to our store in
the past six months. I need to send this out to someone. It take about
three pages and only has one column (Customer Name). I would like to somehow
create a one page report that lists this one column three or four times. So
there would be three rows. The first row would be customers 1-40, the second
would be clients 41-80 and the third would be clients 81 + the remaining
clients. Is there a way to do this?

Thanks,

In Report Design View, click on File + Page Setup + Columns.