finding records with null fields

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

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.?
 
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));
 
Back
Top