Replace a Blank Field with Data

[Guest]

I have a product table with over 43,000 records in it. I would like to place
the same supplier name on all the records in a new field. Search and replace,
unfortunately, will not perform this on a blank field. Ultimately, this table
will merge with several other tables (same issue with these) from other
suppliers. Any thoughts? I am using Access 2003.

 

[Guest]

If you want to update all the records, use an update query to update all the
fields that are Null

UPDATE TableName SET TableName.[supplier name]= "Supplier name"
WHERE TableName.[supplier name]Is Null

Please back up you data before running the update query