This is a multi-part message in MIME format.
Nice, but your solution gives a grand total by part. The poster (Steve)
wants a running total by part and date.
My question is does the poster need this in the query or in a report.
In a report it can be done rather simply by grouping on part in the
report and adding a control that does a running sum over group of the
the qty field.
In a query, it will require a subquery. An accurate solution would be
easier to build if we knew what the poster had tried. So I wouldn't say
that asking for additional information was being lazy.
The query for this might look something like
, (SELECT Sum(B.Qty)
FROM SomeTable as B
WHERE B.Part =A.Part AND
B.Date <= A.Date) as RunningSum
FROM SomeTable as A
That solution has a problem if there is a part and date combination that
is duplicated in the original table. Then things will get double counted.
Access MVP 2002-2005, 2007