Deleting Multiple Records

[The Real Yoda]

Basically I have a table with Results In It Like This

Cert ID Job ID
131 86
131 86
131 86
213 20
213 20

What I want to do setup a way that access looks in this table and deletes any duplicate records.

(So the table shows the records like this)

Cert ID Job ID
131 86
213 20

Does anyone know how to do this as I have about 2-3000 duplicates.


Cheers!!!!

 

[Drew]

There'll be a smart way to do this but the quickest is probably to make a new table with Cert and Job as a compound primary key and then just run an append query - it'll reject any duplicates for you. Nice and easy

HTH

Drew

 

[Liv Manto]

I tried to email you a database sample of these query, your email does not exist.

 

[The Real Yoda]

Thanks Very Much!!!!

I Have Actually Managed To Solve It Another Way By Creating A Query And Using The Max/Min Value. When used without the ID it provides the result that I am after.

I have tried your append query method and that seems to be just as good (Cheers Drew!).

Many Thanks

Yoda

May The Force Be With You........Always!!