I am a novice user of Access 2000 and I am desperate for help! I have to
delete the first 15,000 records of one column only. In excel I would simple
highlight the cells and press delete but obviously this doesn't work in
Access; it wants to delet the whole record, not just the one column. Is
there any easy way of doing this or do I have to do it one by one?????
Excel is a spreadsheet. Access is a database.
THEY ARE DIFFERENT! and require different logic. For one thing, Access
tables do not *have* "cells" - they have Records, where each record
consists of Fields. Secondly, you don't "delete" cells - you change
the value in the cell, you can only delete entire records.
It seems that what you want to do is update 15000 existing records to
replace the current contents of one field with NULL. The appropriate
tool is an Update Query.
First, BACK UP YOUR DATABASE - this change is permanent and you don't
want to lose your data to a mistake in the query!
Create a new Query based on your table. Apply whatever criteria you
need to select those records which should be updated (and note that
there ARE no 'row numbers' - you'll need criteria referencing fields
in the table). Select the field that you want to blank out.
Change the query to an Update query using the query type tool, or the
Query menu option. On the Update To line under the field, type
NULL
just like that - no quotes, no punctuation.
Run the query by clicking the ! icon.
John W. Vinson[MVP]