Update Statement

[Nancy]

Hello,

I have a table that contains the following columns: ID Record, Phone Number,
Fax Number

Some of the Phone Number as well as the Fax Number fields are blank. I'm
trying to update any blank field in the Phone Number and the Fax Number
columns with the value "9999999999".

Please Help!!!

Thanks!

 

[kingston via AccessMonster.com]

Create an update query and use the criteria "Is Null".