Update Query on Yes/No Field

  • Thread starter Thread starter Bookmdano
  • Start date Start date
B

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
 
Bookmdano said:
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
Click to expand...

Sure
update table set active=true where ...
 
Back
Top