Delete only some fields from a record. (1 Viewer)

[sychoangel]

I have a record that has 3 fields;
IP OWNER DATE

How can I set an update query that leaves the entry that is in the IP field, but clears the owner & date details?

 

[pbaldy]

All of them?

UPDATE TableName
SET OWNER = Null, Date = Null

Date is a reserved word and should not be used as a field name.