Update Query based on leaving date

[fishy]

I need to update a table "tbl_trained" with a check box showing the field as
true when I run the query against tbl_AMSemployees and it notes a leaving
date. I have the folloowing but it keeps failing. Any ideas??

UPDATE tbl_Trained INNER JOIN tbl_AMSemployees ON tbl_Trained.[Employee
number] = tbl_AMSemployees.[Employee number] SET tbl_Trained.Leaver = "True",
tbl_Trained.[Date Updated] = Date()
WHERE (((tbl_AMSemployees.[Date Left]) Is Not Null) AND
((tbl_Trained.TR)=False) AND ((tbl_Trained.Leaver)=False));

 

[Duane Hookom]

And your error message is what?

It looks like you are attempting to force a string/text value "True" into a
yes/no field [Leaver]. I would first remove the quotes.