L
Lumpy
I posted this the other day to the general group. Thanks
to Nikos Y. for responding but I don't think I did a very
good job of describing my situation and goals. Here is
another try.
My excel data comes in unsorted. My goal is to sort &
subtotal all the like pieces into a order list. *Not* to
get a total quantity of all the pieces. So I need to sum
the quantity field for all the pieces with identical
Width, Depth and Length. The goal is to produce an order
list that shows only one line for each unique timber size.
<copy & pase of previous post below>
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?
to Nikos Y. for responding but I don't think I did a very
good job of describing my situation and goals. Here is
another try.
My excel data comes in unsorted. My goal is to sort &
subtotal all the like pieces into a order list. *Not* to
get a total quantity of all the pieces. So I need to sum
the quantity field for all the pieces with identical
Width, Depth and Length. The goal is to produce an order
list that shows only one line for each unique timber size.
<copy & pase of previous post below>
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?