finding records with null fields

[Jeff Klein]

I have a table with records that are incomplete. Some of the fields
(PlanID) are null. I am going to update the forms and tables to make these
fields required but I need to update the data in the table first. What is
the easiest way to find records with a null in the "PlanID" field and then
enter a "None" in this empty field. then go to next record.?

 

[Mark]

Use an update query where the field in question (a text datatype) is null:

UPDATE tblPlans SET tblPlans.PlanID = "None"
WHERE (((tblPlans.PlanID) Is Null));