removing duplicates from a table

G

Guest

I have a table that keeps a record of the job number. I the past we have
allowed duplicate jobs in the database. We have recently adjusted the tables
so we now have two linked tables instead of the one to reduce the amount of
data we presently duplicate.

I have copied the relevent fields from the main table into the new one
leaving just some vital details within the main table. these details remain
constant against a specific job number. my problem is that i now wish to make
the job number the index (without duplicates). is there a way of getting
access to strip out the duplicate records as i don't fancy having to trail
through 40,000 records removing the duplicates.

thanks chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to Find Duplicates from Two Different Tables 7
Count ID from one table that matches another and show in a form... 2
Checking for duplicates 1
delete duplicates of choice 1
Increment a number based on instances in another table 1
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
Prevent Duplicates 5
Removing duplicates from a query 4

Top