Query to delete records

#1 August 31st, 2004, 06:47 PM

Hello,

I had placed a posting on design group to clean out my 50 test records from
my tables so i could get a fresh start on my new database.The response was to
use a delete query but i have never created one and do not know how to go
about it.Can someone describe how to make one and if this query will also
reset the autonumber back to zero?
Please help.....Thanks for the support

#2 August 31st, 2004, 07:10 PM

Did you try to search Help on "Delete Query" or "Query - Delete"? How far
have you gotten in your search.

Also, I think your original response suggested you would need to do
something else to reset the autonumber back to zero.

--
Duane Hookom
MS Access MVP

"Jk" wrote in message
...
Hello,

I had placed a posting on design group to clean out my 50 test records
from
my tables so i could get a fresh start on my new database.The response was
to
use a delete query but i have never created one and do not know how to go
about it.Can someone describe how to make one and if this query will also
reset the autonumber back to zero?
Please help.....Thanks for the support

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete Query	JeffH13	Running & Setting Up Queries	6	August 24th, 2004 02:29 PM
EXISTS reserved word in FROM clause	Stephanie Doherty	Running & Setting Up Queries	6	July 21st, 2004 01:15 AM
displaying all the duplicate records in a duplicate query	Paul James	Running & Setting Up Queries	6	July 15th, 2004 09:28 AM
append Query duplicating records	Alex	Running & Setting Up Queries	1	July 8th, 2004 01:31 PM
Query combining multiple records from one table can't add records	Clint Marshall	Running & Setting Up Queries	4	July 8th, 2004 01:25 PM