Access 2000, using data from all records

I have a field called “Price”.

I would like to read all records in the table and average the Price field by 7 days, 14 days, 21 days, etc.

e.g. I’d like to have a new Query field that averages the last 7 records, and another field that averages the last 14 records, etc.