Delete Multiple records

[nintendomasta811]

Hi there,
I'm trying to make a query in which I delete records from a table
based on multiple occurrances. I want to delete records if a
particular field has another equal within the table. For example, if
the "Name" field had two values called "Bob" I would want the delete
query to eliminate BOTH records. How is this attainable?

Thanks in advance.

 

[Guest]

Look at the Find Duplicates query wizard in Access. It creates a Select
query, but you can make it into a delete query.

 

[Steve]

Go to the database window and Queries. Click new and you will see that one
of the options is a duplicates query. Select that option and follow the
directions. When the query is created, open it in design view. Click on the
Type Of Query button in the menu at the top of the screen. Change the query
to a Delete query. When you open that query, manually or in code, it will
delete all your duplicates.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)