By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,910 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Report problem: keeping group header together with detail records

P: 99
I'm sure I knew how to do this once, but now I can't find the place to set it.

A report has a group header for Organisation and then a detail section for each Contact in that organisation. The report shows up just fine, except I don't want it to break a page in the midst of the detail records, or before they start.

That is, I don't want ...

ORGANISATION A
page break
Contact 1
Contact 2

and I don't want

ORGANISATION A
Contact 1
page break
Contact 2

The 'keep together' property SEEMS only to keep the bits of an Organisation together or the bits of a Contact.

Anyone know how I can keep the Organisation together with its Contacts (without forcing a page break before each new Organisation)?
Mar 19 '10 #1

✓ answered by TheSmileyCoder

Well here is a pic from 2007, where I managed to find the stuff.

Hope that helps.


Share this Question
Share on Google+
8 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
In report design, click as shown in the image. This is for Access 2003.

Attached Images
File Type: jpg Grouping.jpg (14.6 KB, 11730 views)
Mar 19 '10 #2

P: 99
Hi, Smiley! Well, your little pic looks very familiar ... I knew I knew how to do this back in 2005.

But ... Access 2007 doesn't seem to have the same facility, or at least not accessible in the same way as per your picture. When you click the groupy thing, your only options seem to be 'Add another group' or 'Choose a field to sort on'. Must be somewhere, I suppose ... I'll let you know if/when I find it.
Mar 20 '10 #3

TheSmileyCoder
Expert Mod 100+
P: 2,321
If its any comfort I can't find anything in Access 2007 either. I haven't really started using it yet, since at work im using 2003, and I only have 2007 at home, but haven't really felt compelled to start exploring 2007.
Apr 6 '10 #4

P: 99
Mmmm! I am 'compelled', as it's what my users will have! Actually, in general, apart from the awful Help system, 2007's quite good. Tracking down where things from 2003 have been moved to is a bit stressful and sometimes (as in this case) unsuccessful! I suppose it is a 'comfort' that you can't find it either, but it will be even more of a comfort when one of us does! If I do find it, I'll let you know.
Apr 6 '10 #5

TheSmileyCoder
Expert Mod 100+
P: 2,321
Well here is a pic from 2007, where I managed to find the stuff.

Hope that helps.

Attached Images
File Type: jpg Group2007.jpg (17.0 KB, 11804 views)
Apr 6 '10 #6

P: 99
Lovely! Thanks so much!
Apr 10 '10 #7

TheSmileyCoder
Expert Mod 100+
P: 2,321
Your welcome.
Apr 12 '10 #8

NeoPa
Expert Mod 15k+
P: 31,186

Post your reply

Sign in to post your reply or Sign up for a free account.