Update Query Trouble

[JJT]

I have a table with 7,000 records with fields Worksite and Category. Half of the records have data in the Worksite field, the other half has no data. What is the Update query that will enable me replace the empty Worksite fields with the word "Used".

Thanks...much.

 

[DJN]

Try the following.
UPDATE tblYourTableName SET tblYourTableName.worksite = "Used"
WHERE (((tblYourTableName.worksite) Is Null));