update query to update yes no field 1

[waymond]

UPDATE Meetinglog SET
WHERE (((Meetinglog.PrimarySic) Between 1000 And 1799));
I need to update a field called ACT based on the criteria above. The field is a yes/no field

thank you

 

[Golom]

UPDATE Meetinglog SET [COLOR=blue]ACT = TRUE[/color]
WHERE PrimarySic Between 1000 And 1799;