Keeping Groups together (1 Viewer)

statsman

Registered User.
Local time
Yesterday, 19:00
Joined
Aug 22, 2004
Messages
2,086
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

Registered User.
Local time
Yesterday, 19:00
Joined
Aug 22, 2004
Messages
2,086
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
Yesterday, 19:00
Joined
Jan 23, 2006
Messages
13,204
Glad you have a solution. For reference I think this is the link involved.
 

theDBguy

I’m here to help
Local time
Yesterday, 16:00
Joined
Oct 29, 2018
Messages
10,766
Hi. Just for future reference, did you end up using the "keep group together" option?

Edit: Oops, too slow...
 

statsman

Registered User.
Local time
Yesterday, 19:00
Joined
Aug 22, 2004
Messages
2,086
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 (Users: 0, Guests: 1)

Top Bottom