Update Query on Yes/No Field

[Bookmdano]

Is it possible to use an update query to "check" a yes/no field? I have an
employee table that I track Active employees. If the box is checked then the
employee is active. Thanks

 

[Bob Barrows [MVP]]

Is it possible to use an update query to "check" a yes/no field? I
have an employee table that I track Active employees. If the box is
checked then the employee is active. Thanks

Sure
update table set active=true where ...