Calculating a group total in a query

[Guest]

Is there a way to calculate group totals in a query. I want to sum up the
value of several items per box #.

 

[John W. Vinson]

Is there a way to calculate group totals in a query. I want to sum up the
value of several items per box #.

Yes; use the Greek Sigma icon (looks like a sideways M) in query
design view. Group By the box # field and Sum the desired fields.

Note that you can see the individual records... *or* the box sums...
but it's more complex to see both in the same query. If you want to
see both, it's probably better to use a Form (for onscreen) or Report
(for printing), and put controls in the Form/Report Footer with
control sources like

=Sum([fieldname])


John W. Vinson [MVP]