Update Query

[Mike Hughes]

Attached is a DB.
I'm trying to update the CASE table. But the update query has something wrong with it. Would someone please look at the update query and see if it appers I'm doing something wrong please.

Thanks, Mike

 

[Trevor G]

Mike the majority of your tables are all tide to other systems so the query can't be checked.

Can you create a copy of the data in the 2 tables and place in the update query.

Although I could see the query design I don't get what you are trying to achieve so if you can explain in the thread that would assist in looking at the query.