Access Tech Support

[Glen]

Upgraded to Access 2000 and I feel like I've gone stupid.

Here is my problem: I am trying to delete an entire date of races...5/08/01.
Access tells me when I run this query to list all races on 5/8/01 that it is read only and I can not delete.

Question: Besides going into my table and deleting the record, what kinda query can I set up to delete all races on 5/08/01.

Thanks,
Glen

[Rick]

Glen,
There are many ways.

A simple way I use when I am not sure about how to enter the dates in a query for something simple like this is to just sort the table on date. Then highlight all the records that have the 8 May date and delete.

I would normally open the table and click on the Filter by Form icon. Under the date field enter 8 May 01 (I am guessing that date is 8 May instead of 5 Aug - logical choice) and click on the Apply Filter icon.

Double check that it selected the right records, click Edit, Select All Records, and click on the Delete icon. When exiting the table and it ask if you want to save changes, always answer NO.

Now someone else can tell you how to do it with a delete query.

[MikeDee]

To delete with a query.

First thing make sure the table is not open or that another query is not open that is using the table, you cannot delete something in the table if it is in use by something else. And you cannot delete something if there are two tables in the design field and they are joined.

Make a new query on the table with the data to be deleted. In the design mode put the table with the data and in the first column put the date field. In the first line of the criteria put the date that you want to delete.

Now go up to the query type icon and click on the down arrow and click on delete query.

When you run the query it will delete any data records with the date that you put in the design grid.

WARNING be sure to put something in the date field before you execute the delete query. If you don't, if the field is blank, it will delete ALL of your records.

Been there done that and it is not pretty

[Glen]

Thanks guys