yes/no option in a table

[Avi]

Write an UPDATE query.
Suppose the name of the column you are trying to set is
ActiveBuisness.


select ActiveBusiness. In the Update row write 0 (zero)
and in the Crietria row write -1 (Minus one).

This will set all the 'Yes' to 'No'

You could write a little macro that will create the report
and update the records. (will save you some time and will
make you efficient!)


Cheers,

Avi