Keeping Groups together (1 Viewer)

statsman

Active member
Local time
Today, 05:04
Joined
Aug 22, 2004
Messages
2,088
I'm using Access 2007.
I have a report for the players in a league. There are only 4 members per team and the data is pretty simple. Just the name, team and the games played and won.
I have them grouped by team and in two columns in the report.
What I would like to do is keep each team together, either in the column or the page. What I am getting now is run over with the same team in two columns or on two pages.
Is there a way to tell the report that if there isn't enough space left in a column or on a page, to go to the next column or page?
 

statsman

Active member
Local time
Today, 05:04
Joined
Aug 22, 2004
Messages
2,088
So I scrolled down a big and found wiklendt's contribution on this subject and it works perfectly.
Amazing function that search button.
Sorry if I wasted your time.
 

jdraw

Super Moderator
Staff member
Local time
Today, 05:04
Joined
Jan 23, 2006
Messages
13,715
Glad you have a solution. For reference I think this is the link involved.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:04
Joined
Oct 29, 2018
Messages
15,227
Hi. Just for future reference, did you end up using the "keep group together" option?

Edit: Oops, too slow...
 

statsman

Active member
Local time
Today, 05:04
Joined
Aug 22, 2004
Messages
2,088
Hi. Just for future reference, did you end up using the "keep group together" option?

Edit: Oops, too slow...

That was what I used. I almost never use columns or grouping in reports so I wasn't even aware this function existed.
 

Users who are viewing this thread

Top Bottom