Format columns in Access Report

[bmoberly8888]

We have 21 Practice Groups with 6-30 people in each. I am trying to create a Report by Practice Group but I need to have 2 columns for names if there are more than 6-8.

I need to have 2 columns (if necessary) for each Practice Group - not the entire list (if that makes sense). They also need to be in a certain order - so the names need to go down then the extra names go in the next column for that Practice Group.

 

[OnTheFly]

Have you tried setting the column properties in the page set-up of the report?

Hope this helps.

OnTheFly

 

[bmoberly8888]

Yes I have - but that formats all of the information - not just by each section.

 

[OnTheFly]

Do you have the report Grouped by Practice Group with a group header?

Hope this helps.

OnTheFly

 

[bmoberly8888]

Yes.

 

[OnTheFly]

I guess I am not understanding what you are trying to accomplish. When I create a report say with the following fields

PracticeGroup, Name

If I group by PracticeGroup
and set up my columns to be 3" wide and 2 columns

If there are more names than will fit on a page it will wrap the rest to the second column.

Is this what you are trying to do? If so, than this procedure should work. If not, then I am not understanding what you are trying to do.

Let me know.

 

[bmoberly8888]

I am wanting it to wrap to the next column within each Practice group - so if there are 3 practice groups on the page - each one might have 2 columns depending on the number of names. Like this:

Appellate Group John Doe John Smith
Mary Doe Mary Smith
Tom Stevens Jill Brown
Bob Dole Jimmy Carter
Ray Vaughn

Business Bob Jones Bill Smith
Susan Clark John Franklin
Reggie Miller Cindy Crawford
Van Morrison George Bush
Steve Miller

 

[OnTheFly]

That becomes more difficult, in fact, I am not sure it can be accomplished without a lot of coding. Access has no way of knowing that you want two columns until it hit the end of the page. Now you could probably do it by going Across then down but you said you don't want them sorted that way.

Sorry about that.

Hope this helps.

OnTheFly