How to update to Null

[JA]

How do you delete - using a delete query - so that it will leave the field
Null? I tried using " " and "", but both leave something there. I don't want
to delete the whole record, just the data in one field.

Thanks!

JA

 

[JA]

I guess I meant how do I UPDATE to null, not delete.

 

[M.L. Sco Scofield]

You're right. You want to do an update, not a delete.

In design view, use the "Query Type" button to turn your query into an
update query.

Bring down the field you want to clear and in the "Update To" row, simply
enter the keyword Null.

Unless you want to clear this field for all records, bring down other fields
as needed to specify criteria while leaving the "Update To" row blank.

Just remember that you can not override any validation rules that require
the field to contain data.

Good luck.

Sco

 

[Van T. Dinh]

UPDATE YourTable
SET YourField = Null

*provided* that Null is allowed for this Field in the Table Design.