Update Checkboxes

[EllenM]

Hello,
I'd like to add checks to some checkboxes with an update query. My guess on
how to do it looks like this:

UPDATE FCNsOnTheWeb INNER JOIN ScanTracking ON FCNsOnTheWeb.TextField2 =
ScanTracking.TextField2 SET FCNsOnTheWeb.ScanningComplete = "yes";

Can someone help me?

Thanks in advance,
Ellen

 

[EllenM]

Ha ha, I got it:

UPDATE FCNsOnTheWeb INNER JOIN ScanTracking ON FCNsOnTheWeb.TextField2 =
ScanTracking.TextField2 SET FCNsOnTheWeb.ScanningComplete = True;

I appreciate this forum!! I think merely posting a question sometimes
provokes enough thought to solve the problem.