Group & Reports (more than 4 Groups??)

[JohnS]

Hello to all & thanks for your help!!

OS: Windows XP
Access Version: 2007

So, I used the Report Wizard to create the foundation of my report. But as we all know, the wizard only allows you to create 4 levels of grouping.

I need to add another 3 level of grouping, which would give a total of 7 groups. According to the Help file, Access can handle up to 10 levels of groups. So adding another 3 shouldn't be problematic. (So why I am here then?!)

I'm going to try and give u as much info as I can:
Report Header: 1 label


Page Header: has 9 Labels (I need to group on 7 first of the 9)
Field 1 Header: (blank)
Field 2 Header: (blank)
Field 3 Header: (blank)
Field 4 Header: (blank)
Field 5 Header: (blank)
Field 6 Header: (blank)
Field 7 Header: (blank)
Details: 9 text boxes related to label
Page Footer: 2 text box (Date and Page number stuff)
Report Footer:Blank


If you could see my layout view and turn on the "Group & Sort" function, you would see 7 levels of group each saying Group On field X (1 through 7)

Why is it only showing 4 levels of grouping and not the 7???

Thanks

FYI - I am an Access Newbie, please keep that in mind when your respond

and If you wondering why I need 7 level of grouping, my DB already has a 150K record by 30 columns is what I would call my "Master Table"

[dcrake]

Have you tried adding the groups manually yet?

[JohnS]

If by manual you meant right clicking on the text box and selecting group on, then yes.

[JohnS]

After much hair pulling...I think I have to the conclusion the you Access can indeed handle 10 groups, BUT with a Maximum of 4 for Header.

Can any confirm this?