Resetting Yes/No fields

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

Guest

Hello

I have a database that keeps track of attendance to 8 meetings. At the end of the year
I have to reset the entire attendance record for incoming pledges.
Is there a way I can do this in an update query for everything at the same time
There are no conditions; it's just if it's yes, change to no

Thanks

John.
 
John,

Yes, an Update Query can do this. Make a query in design view based on
your Attendance table, make it an Update Query (select Update from the
Query menu), add the Yes/No field to the query design grid, enter 0 in
the Update To row of the grid, and then run the query (click the toolbar
button with the red ! icon).
 
Back
Top