update query to chg value of checkbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to set the value of a checkbox to "yes" or "true" via an
update query? I have run a query which shows outdated records that I would
like to flag for deletion. Any ideas how to sucessfully do this?
Thanks!
 
would this be done in the "update to" row? I have the code in place but get
an error due to key violations. I'm thinking I need additional code to turn
off the primary key or something.
 
There should be no key violations as the field for a checkbox would not be a
key field.
Post your SQL statement. In design view click on menu VIEW - SQL View and
highlight all, copy, and paste in a post.
 
Back
Top