Filling in null values

  • Thread starter Thread starter Hsu Ken Ooi
  • Start date Start date
H

Hsu Ken Ooi

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
 
Back
Top