How to subtotal?

  • Thread starter Thread starter Lumpy
  • Start date Start date
L

Lumpy

Newbie question. I've got a table of timbers that I
imported from excel. The table has fields for Qty,
Width, Depth and Length among others. A portion of the
list might look like this:
Qty W D L
12 5.5 11.5 16
2 1.5 7.5 14
3 5.5 11.5 16
6 1.5 7.5 14
4 1.5 7.5 12

I need my query to return a compiled list of these
timbers like this:
Qty W D L
15 5.5 11.5 16
8 1.5 7.5 14
4 1.5 7.5 12

Any idea how to do this?
 
Easy... open a new query in design view and add the table. Get all four
fields down to the grid (by double-click or drag'n'drop), then go to menu
item View > Totals. Notice the new line that appears in the grid, headed
Total. All fields' default setting is Group By. Just change to Sum for the
quantity field only, and you're done!

HTH,
Nikos
 
Back
Top