Update Query on Yes/No Field

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
 
B

Bob Barrows [MVP]

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

Sure
update table set active=true where ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top