Calculating a group total in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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]
 
Back
Top