 <p>Are you saying your are getting results like this:</p> <pre><code>Group 1a Group 2a Foo1 1 Foo2 1 foo3 2 Group 2a Sum 4 Group 2b Foo1 3 Foo2 3 Group 2a Sum 6 Group 1a Sum 10 Group 1b Group 2a Foo1 4 Foo2 1 foo3 2 Group 2a Sum 7 Group 2b Foo1 4 Foo2 3 Group 2a Sum 14 Group 1b Sum 21 </code></pre> <p>This is the behaviour I would expect. I was able to do it by putting <code>=Sum([value])</code> in an unbound field in each group footer (and even in the report footer).</p> <p>I know 'works for me' isn't very helpful.</p> <p>Have you labelled the detail's values fields (or the summary fields) with the same name as the data source? Sometime MS Access has weird behaviour if your fields have the same name as their bound data source (I tend to rename them slightly so I'm sure what I'm referring to in code).</p>