SURE! Thanks for the reply.

Lets say that the last update of "Earned" hours was on "WeekEndingDate"
10-5-08. The Earned value was 100 hours. The way my code is set up is that an
entry can be made any time within the date range of 9-28-08 to 10-5-08 and that
"Earned" value would be updated on "WeekEndingDate" 10-5-08. Now this week a
Project Engineer may not update a value this week because nothing has been
earned. This will break the program. I have to update this table automatically.
So in the date range of 10-5-08 to 10-12-08, I need to look at the
"PercentComplete" value for "WeekEndingDate" 10-12-08 in an Update Query
(preferably) and search for a NULL value. When the query finds those records. I
need to update that record with the weeks prior
(WeekEndingDate=10-5-08;Earned=100)"Earned" and "PercentComplete" value. I hope
I didn't confuse you more.

The null value is important.