Report problem: keeping group header together with detail records

[julietbrown]

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)?

[TheSmileyCoder]

In report design, click as shown in the image. This is for Access 2003.
[imgnothumb]http://bytes.com/attachments/attachment/2921d1269012145/grouping.jpg[/imgnothumb]

[julietbrown]

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.

[TheSmileyCoder]

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.

[julietbrown]

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.

[TheSmileyCoder]

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

Hope that helps.

[imgnothumb]http://bytes.com/attachments/attachment/3010d1270576793/group2007.jpg[/imgnothumb]

[julietbrown]

Lovely! Thanks so much!

[TheSmileyCoder]

Your welcome.

[NeoPa]

For future reference, Interactive: Access 2003 to Access 2007 command reference guide may help.