Deleting all values in a field

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

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,
 
Backup the database.
Use an update query and in the 'Update To' row of the design grid put NULL.
 
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.
 
ChuckW said:
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.
Click to expand...


Run an Update query abd set the field to Null?

UPDATE SBMSALE2008 SET HPProductLine = Null
 
Back
Top