Check Box Query

[kitty77]

I have a form with a check box that I use when I run a query. I'm able to pick off records that are true. I use it to run a report.
How can I create a query that would un-check or make that field be false for all records that are true? I don't want to delete the record, just un-check the box.

Thanks.

 

[theDBguy]

You can use an UPDATE query.

UPDATE TableName SET CheckField=False

 

[kitty77]

Could you give me an example? Are you using the wizard?

You can use an UPDATE query.

UPDATE TableName SET CheckField=False

Got it. Thanks!

 

[theDBguy]

Could you give me an example? Are you using the wizard?

Got it. Thanks!

Good luck!