chrispilie wrote:
> in an Update Query (preferably)

Assuming the records already exist, and there is only a single record for each week, an update should work.