Clearing and entire column

[MaineLady]

How can I clear an entire column in a table?

[CJ_London]

depends if this is a onetime requirement. You could go into table design, delete the field then save then reinstated the field if required

Or with a query, if you just want to remove the values

UPDATE myTable
SET myField=Null

[MaineLady]

This is something that I have to do once a year. The field that I want to clear impacts other fields that are calculated based on the entry in the first field. So I'm going to go with the Query method.

Thank you.