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"