chrispilie wrote:
> Problem that I am trying to solve is there is a possiblily that these
> values may not be updated weekly for a number of reasons. I would like
> to query the data table for the week prior and update the value with
> that prior week value automatically every Sunday evening.

This is confusing. What do you mean by "the week prior" and update it with
"that prior week value". Can you provide an example with actual dates?