how to reset a group of yes no records to no

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

Guest

I have 37 records with a field yes/no and I need to set all these fields back
to no. I need to have this done automatically.

Please help
 
This is about as automatic as it gets:
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE tblNoNameGiven SET SomeFieldName = 0"
DoCmd.SetWarnings True
 
I am not entirely sure what "automatically" means, but you could
"automatically" run an update query from code or a macro......
 
Back
Top