Dear MV:

I'm guessing you want a "running sum" something like this:

PO    SPrice    SHandling    SFreight
111    10            3                2
111    18            5                3
112    15            5                4
112    37          11                9
112    45          12              11
115      9            2                1
115    22            5                4

There is a big problem in doing this.  The rows of your data are not
uniquely sorted.  When it comes time to look at the data and add up the
price on the "current line" with the price on all the "previous lines", how
can we know which lines are previous to others?  How can we tell the order
is:

111                   10            3             2
111                   8              2             1           2

and not:

111                   8              2             1           2
111                   10            3             2

If you cannot sort the data uniquely, then the rows within each set for a PO
are not ordered at all.  They will not necessarily appear in any consistent
order, because they are not uniquely ordered.

If you have a column that adds order to the rows within a set, then this can
be done in a query.  Just tell me what column that is.

There is a mathematical term for this, it is a "bag".  The jelly beans in
each bag (each different PO value) are being drawn out in no particular
order.  This order will seem systematic for a while, but if rows are added
and deleted from the table (even form a different PO value) this order can
change.

I've made too many guesses already.  Please just let me know if I'm on a
track that is anywhere close to what you need.

Tom Ellison