Query that keeps totals every week for Graph Report

[Tadynn]

I've set up a query that shows me running totals of stock stored. I now want to have these total values and the date stored in a table every week. This is so that I can set up a graph that will show me all weekly balances over whatever period the user specifies (whether it be weeks, months, or years). Can anybody help me???

I've pasted the query that gives me my running balance below.

SELECT LocShed4All.Loc, LocFullShed4.SumOfQty, LocFullShed2.SumOfQty, LocShed4All.PutawayZone
FROM [Putaway Zone] INNER JOIN ((LocShed4All LEFT JOIN LocFullShed4 ON LocShed4All.Loc = LocFullShed4.Loc) LEFT JOIN LocFullShed2 ON LocShed4All.Loc = LocFullShed2.Loc) ON [Putaway Zone].[Putaway Zone] = LocShed4All.PutawayZone;


Thanks in advance.
Tadynn.