clearing an entire column in access

Question

is there a way to clear an entire column in a datasheet in access? i can just right click on it and delete it but that will affect the structure, i just need to clear all the records. how do i do this?

perhaps the question i should be asking is how do i clear the entire contents of a datasheet in access?

Answer 1

UPDATE table_name
  SET field_name = NULL;

Answer 2

Use an update query, e.g.

UPDATE YourTable 
SET YourColumn = NULL

There doesn't seem to be a way to do this directly from the UI, which kind of makes sense.

See

• Update data by using a query - Microsoft Office Online

Answer 3

right click on upper left square of the datasheet, click DELETE RECORD