Update Checkboxes

  • Thread starter Thread starter EllenM
  • Start date Start date
E

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
 
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.
 
Back
Top