Mass update to check box field

J

Jeff

I have a field labeled "corrected" and after I have viewed the records in the
query and made changes, which in turn are reflected on the main database, is
there a way to mark all the records in query as YES or True instead of going
through and having to mark each record individually.
 
J

John W. Vinson

I have a field labeled "corrected" and after I have viewed the records in the
query and made changes, which in turn are reflected on the main database, is
there a way to mark all the records in query as YES or True instead of going
through and having to mark each record individually.
Click to expand...

Sure. Make a copy of the query using the same criteria (you don't say what
those might be); include the Corrected field; change the query to an update
query (using the Query menu option, or the query type icon on the toolbar);
and put

True

(or, equivalently, -1) on the Update To line under Corrected. Run the query by
clicking the ! icon, or execute it from a command button on your form.
 
Top