Thanks! SQL has been my weekness. I actually tried a couple of statements much
like the one you are recomending that I found. They had been kicking out
errors. Most of them were syntax errors so I figured Access wasn't accepting
it. I would love to use one like this. I am getting this error however.

Syntax error (missing operator) in query expression 'R.PercentComplete FROM
Productivity'.

A little more info:
I am using Access if that helps. I do have the date field set as a date/time
data type. I am trying to update and existing row.