Results 1 to 4 of 4
  1. #1
    rhewitt is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    74

    Group on a single field twice

    I'm trying to Group By a single field twice. tblObjective has two 1:M relationships; I would like to have both of those tables grouped at the same level (see attached photos).



    According to MS Access Docs:

    You can group on any fields and expressions you sort on (up to 10). You can group on the same field or expression more than once. When you group on more than one field or expression, Office Access 2007 nests the groups according to their group level. The first field you group on is the first and most significant group level; the second field you group on is the next group level; and so on. The following illustration shows how Office Access 2007 nests the groups.
    Desired:

    Click image for larger version. 

Name:	desired.png 
Views:	10 
Size:	2.0 KB 
ID:	25549
    In Access Group & Sort: What do I have to do? Is it possible?
    Click image for larger version. 

Name:	current.png 
Views:	10 
Size:	4.3 KB 
ID:	25550

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    If I understand correctly, you want to use a subreport within your Report Object.

  3. #3
    Bulzie is online now VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    I don't think you can group on 2 fields at the same level. Maybe combine both fields into 1 and then group on that field?

  4. #4
    rhewitt is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    74
    Thanks, I created two subreports for Management Activities and Monitoring Activities that tied back to the ObjectiveID field of a parent form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. updating single row per group in access query
    By sugat11 in forum Queries
    Replies: 6
    Last Post: 07-05-2016, 08:03 AM
  2. Replies: 6
    Last Post: 06-09-2015, 09:51 AM
  3. Replies: 3
    Last Post: 04-28-2015, 02:16 AM
  4. Replies: 1
    Last Post: 04-16-2013, 09:51 PM
  5. Replies: 16
    Last Post: 04-11-2012, 10:56 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums