chrispilie wrote:
> I am getting this error however.

Ken's suggestion is on target. While he mentioned it is untested, the syntax
looks correct to me. At least for databases like MS SQL. MS Access seems to
require some tweaking. The best adaptation I could come up with was something
like this. But I am very rusty on Access. So I am sure it could be improved.


UPDATE Productivity AS p, Productivity AS R
SET p.Earned = R.Earned,
p.PercentComplete = R.PercentComplete
WHERE R.WeekEndingDate = #CreateODBCDate(dateadd("d",-7,todaysDate))#
AND p.WeekEndingDate = #CreateODBCDate(TodaysDate)#
AND p.Earned IS NULL