Delete only certain fields from a record (1 Viewer)

[azzurri]

I had try to use Delete query but it will delete the record totally, is there a way to delete certain fields from a record without deleting the record itself?

Thanking in advance.

 

[antomack]

Use an update query and update the fields you want emptied to Null.

 

[azzurri]

Thanx. Couldn't thought it would be to simple a solution.