Search results

I have a table with duplicate rows. How do I de-duplicate the table so that there are no duplicates and find out how many duplicates there were in the table. Thanks:)

You must think i'm really stupid!! (but your right!) Am reading some stuff on elimitaing duplicates from an access manual i've got so should be ok with part 2 (I hope!). Parts 3 and 4 are just settign my queries i take it.? I use queries on my work databases now and modify them from time to time...

I know it does sound like a school project but it isnt. Its for some analysis work but just cant figure out how to tackle this part of it. I use Access databases but dont really develop in it. Thanks for yor reply though.

Am new to this forum so not sure is this is the right place to post my question. basically been given a task to complete but not sure how to do it. i'm sure its simple for Advanced users but not for me!! Havent been given the data yet but below is the question... Background: You will be...

Am new to this forum so not sure is this is the right place to post my question. basically been given a task to complete but not sure how to do it. i'm sure its simple for Advanced users but not for me!! Havent been given teh data yet but below is the question... Background: You will be...