Reset my running sum with new/different date range(s)

K

Kevin0862

How can I restart my running sum when I enter a new date range? It appears
that I'm getting all of the previous months prior to the date range that I
have selected in my query.

RunTotItemsComp: (SELECT Sum([Items Completed]) FROM [qryItems Completed by
Day Results subqry] A WHERE A.[Completed Date] <= [qryItems Completed by Day
Results subqry].[Completed Date])

Current Results

Associate Completed Date Date Items Completed RunTotItemsComp
Jane Doe 4/1/2005 6
8100
Jane Doe 4/2/2005 3
8103
Jane Doe 4/3/2005 17
8241

Results Required

Associate Completed Date Date Items Completed RunTotItemsComp
Jane Doe 4/1/2005 6
6
Jane Doe 4/2/2005 3
9
Jane Doe 4/3/2005 17
26
 
K

Kevin0862

Disregard... my criteria fields in my subquery had to be updated to match the
active query.
 
Top