Okay I know what the problem is. The Access query I have is missing a join statement. There is a a Table in my Access Database being linked to another...

I can produce the query into MS SQL Select statement, but I can't figure a way to convert it to an Update Statement.

SELECT * FROM TableA,TableB

WHERE (TableA.CapCode='' AND

...

Thanks for the quick reply. I never heard of a Cross Apply until now. I have corrected the syntax as much as possible, but still get this error message:

Column 'FC.CHECK_DATE'...