Deleting information but keeping certain columns

[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.

 

[John Vinson]

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.

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.