Deleting all values in a field

[ChuckW]

I have a field called HPProductLine in a table called SBMSALE2008. I want to
delete all values in this field and replace them with null values. There are
80,000 records in this table. I don't want to delete and recreate this
field. How do I do this?

Thanks,

 

[KARL DEWEY]

Backup the database.
Use an update query and in the 'Update To' row of the design grid put NULL.

 

[Allen Browne]

BACKUP FIRST.

1. Create a new query, using this table.

2. Change it to an Update query.
(Update on Query menu.)
Access adds an Update row to the query design grid.

3. In the Update row under your HPProductLine field, enter:
Null

4. Run the query.

 

[Marshall Barton]

I have a field called HPProductLine in a table called SBMSALE2008. I want to
delete all values in this field and replace them with null values. There are
80,000 records in this table. I don't want to delete and recreate this
field.

Run an Update query abd set the field to Null?

UPDATE SBMSALE2008 SET HPProductLine = Null