Not those dates.

I want to specify a certain number of days as my count. Lets say 7 days.

Sum, starting with the most recent date since NOW, which matches my criterion (allocation = 100), the weight and divide that by the count. Of course the columns used in the recordset are date(date), allocation(integer), and weight(integer).

The result would be something like--
The 7 day average for A1 at 100 = 2,425

Any help would be greatly appreciated.
Thanks