Deleting information but keeping certain columns

  • Thread starter Thread starter mary
  • Start date Start date
M

mary

Is there a way to delete a row, but keep information in
certain columns of that row. Like delete the name,
address, and city information but keep the state and zip
information.
 
Is there a way to delete a row, but keep information in
certain columns of that row. Like delete the name,
address, and city information but keep the state and zip
information.
Click to expand...

Turn your thinking around.

A Delete query deletes an entire record, or nothing at all; not in
between.

What you want is an Update query updating the name, address, and city
fields to NULL.

This would be a rather strange thing to do, of course; if you just
want to *see* the state and zip, and might want the name and address
again later, simply create a query selecting only those fields.
 
Back
Top