Query to change all null entries in a table to a specified amount

[Guest]

Hello,

I wonder if you can help.

I have a query that opens up all the records where there is no entry in a
field called GameFormat.

What I would then like to do, is have a certain number put into all of those
empty fields. i.e. I would like to input the number 11, and for that to
appear in all the empty format fields.

Is this kind of thing possible?

Thanks,

 

[Guest]

Oops! Figured it out - used an Update Query.

Cheers!