Null value in Yes/No field

[MikeB]

I'm adding a new Yes/No field into an existing DB. I will update
some of the records based on data in other columns (To be precise,
previously I had a fake player number to indicate if a game was a Bye
game, now I'm adding a field to indicate if the game is a Bye. So I
will run an update query to update the field for those records where
the opponent was the fake player)

Do I have to run another query to set the field in all the remaining
records to "No" or will the null value suffice? Will queries blow up
if they are looking or "No" and encounter Null?

Thanks.

 

[Steve Schapel]

Mike,

A Yes/No field cannot be Null. If you add a new Yes/No field to the
table, and then Update its value to Yes for some records, its value will
be 0/No for the remaining records.

 

[MikeB]

Mike,

A Yes/No field cannot be Null. If you add a new Yes/No field to the
table, and then Update its value to Yes for some records, its value will
be 0/No for the remaining records.

Thanks. Rats, I wish I'd waited for a response. I spent an eternity
crafting an update query with "not Yes" as the criterion for the
field.