How can you delete just the contents in a Access Database column?

  • Thread starter Thread starter Elteeca
  • Start date Start date
E

Elteeca

When working in a Access Database, I wonder how I can delete the contents of
a database column. The only option I see for deletion is to delete the
entire column. I want to delete just the contents of the column.

Any suggestions would be helpful.
 
On Tue, 21 Jul 2009 06:35:01 -0700, Elteeca

You can use an Update query:
update myTable
set myColumn = null

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top