find and replace data in a yes/no field

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

How do you find and replace a Yes/No field? I want to find all no entries
and globally replace them with a yes entry.

Any assistance is deeply appreciated.
 
Write a query

UPDATE MyTable SET MYyesno = Yes WHERE MYyesno = No;

The where clause is unnecessary if every row has a value, since you'll be
making them all True anyway.
 
Arvin:

Thanks a bunch.

What I did was go to the table that had the yes/no field and made the yes/no
field a text field. Once that was done, the find and replace function
worked. After data correction was complete, I went back to the table and
changed the yes/no field back to the check off box option.

Your method also works great as well and is probably the best way to handle
it.
 
Back
Top