Remove all data from Column without deleting field

[GraemeG]

Hello,

I had a default value of "1" in a field and this populated all 10000+ records.
I have now removed this value as it is not needed but the specific field (column) is populated with "1". If I try and delete it states that it will remove the field and data.
Is there a way just to remove all the data from that one field (column)?

Thanks

 

[CBrighton]

A simple update query.

Assuming it should be removed from all records then you just need a query with just that field, no criteria and update to: null

 

[GraemeG]

Its ok sorted!
Did a find and replace in that specific column.

 

[boblarson]

Its ok sorted!
Did a find and replace in that specific column.

It would be better to use an update query as suggested by CBrighton as it is more efficient. Just so you know for the future.

 

[ComptechRx]

What if you want to delete all data in a Memo filed that is set to append? I tried using the above method, but all it did was add blank entries which were recorded.