Partial Delete Query

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Access 2000. I need a delete query that will only delete the contents of
one or two fields in a table. I have a table named "EMP" 2 of the fields
are named "FirstDay" and Last Day" I need to delete the entries of these two
fields, not the data of the other fields...Thanks...Randy
 
Randy said:
Access 2000. I need a delete query that will only delete the
contents of one or two fields in a table. I have a table named "EMP"
2 of the fields are named "FirstDay" and Last Day" I need to delete
the entries of these two fields, not the data of the other
fields...Thanks...Randy
Click to expand...

That's not a Delete query, that's an Update query. A Delete query is used
to delete entire records. An update query can be used to alter the data in
individual fields including setting those fields to Null.
 
Your right, thanks for the tip..Randy

Rick Brandt said:
That's not a Delete query, that's an Update query. A Delete query is used
to delete entire records. An update query can be used to alter the data
in
individual fields including setting those fields to Null.
Click to expand...
 
Randy said:
Access 2000. I need a delete query that will only delete the contents of
one or two fields in a table. I have a table named "EMP" 2 of the fields
are named "FirstDay" and Last Day" I need to delete the entries of these two
fields, not the data of the other fields...Thanks...Randy
Click to expand...


Use an Update query to set the field's value to Null

UPDATE Emp SET FirstDay=Null, [Last Day]=Null

Be sure to test this on a copy of your table in case you
make a mistake and wipe out some good data.
 
Back
Top