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:
Desired: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.
In Access Group & Sort: What do I have to do? Is it possible?