Hi group,

I'm rather new to Access so bare with me.  I have a table of survey
results where a person could answer yes or no.  If they answered yes
then the appropriate cell is filled in with a yes.  However if a person
answered no the field is left blank or null.  I'd like to fill all the
null values in the table with no.  I realize that I could run a query
for each column, where each field is null update with "no" but I was
curious to know if there was a way I could do this to all columns at
once?

Note:  I tried running a query on all the columns, where if null update
to "no" but I think Access takes this as several conditional "and"s.
It only makes changes when ALL columsn are no.

Thanks in advance!

hk