Lisa, Welcome - To delete the contents of a table: 1. In MyComputer or Explorer double click on your Access database (MDB). This will put you into design/developer mode. 2. You will see a vertical list of things to be developed with name like table, form, query, etc. Go to the Table tool and double click on the table you want to empty. 3. Once you can see all the entries in that table do EDIT/SelectAll 4. Then do EDIT/Delete - The table will now be empty.
Alternatively you could write a Delete Query - 1. back where there was the vertical list of table, form, query, etc. and choose Query. 2. Click on New 3. Choose Design View 4. Close the Show Table box (start with an "empty slate") 5. Choose View/SQL view 6. Key in "Delete From yourtablename" 7. Close the Query SQL development box and name your query Then in the future when you click on this new query yourtablename will be emptied I usually have a service/utility form from where I run various different functions. On that form I would add a new button that runs the delete query. Dick --- In [email protected], "eakdxl" <[EMAIL PROTECTED]> wrote: > > Hi everyone, > > I just joined the group but I have very limited knowledge of Access. > Basically I input data for a food pantry every month. Each year the > database is copied and retains all records. There are three tables and > one of them should have the information in the columns deleted. The > columns are strictly used to record dates of visits and change from > year to year. I would like to know if it is possible and how to do it > to save me from deleting each entry to set up the database for 2007. > Hope this makes sense. As you can see, I am a real novice and any help > you can give me would be truly appreciated. > > Lisa >
