I need help with access

G

Guest

How would you delete all the info in the same column going down? In excess you can highlight down the colum and just hit delete, how would you do that in access 97, without..arrowdown, delete, arrowdown delete ect..fingers get tired after doing 1000 some odd cells..
 
R

Rick Brandt

Tamara Miller said:
How would you delete all the info in the same column going down? In excess
you can highlight down the colum and just hit delete, how would you do that
in access 97, without..arrowdown, delete, arrowdown delete ect..fingers get
tired after doing 1000 some odd cells..

Access is a database, not a spreadsheet and the tools/methods are different.
In a database you would use an update query to do this.

UPDATE SomeTable
SET SomeField = Null
 

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

Top