Fjerne dupletter i en tabel!!

well, I would suggest that you make a query which selects UNIQUE records and INSERTS them into a TEMP table. Then delete the originla table and then you can either copy all records from the temp table back into th eoriginal table or delete the original and then rename the TEMP.

One could ask WHY there are duplicates? If your database was designed correctly then you should NOT be able to create duplicates.

Can you please be a little more specific, i´am kind of a newbie

Åbn din db i databasevinduet > Fanen forespørgsler > Ny > Forespørgselsguiden Find dubletter.

Følg guiden og du får det ønskede resultat.

Tak for det

Velbekomme.

Terry: See, you are explaining and educating, but that's not what the kids are looking for, they want solutions...

Arnvig>> Can you please tell me have to delete the duplets in my tabel?? It would realy help me.... My database can´t handle duplets so and thats the point yea??

Edske, du har allerede fået svar på dit spørgsmål, fra MUGS. ikke ?

OK, jeg opretter et nyt spørgsmål

arnvig>what are you getting at? People are allowed to think for themselves and some idea help them do that!
Just to point something out - mugs has given a solution which edske has accepted (even though he cant get it to work)! and now YOU have the chance of giving him a solution :o)

sorry this isnt a solution, but it WILL help you on the way in making one.

http://office.microsoft.com/assistance/2002/articles/acDeleteDuplicates.aspx

Terry: Sorry, i'm just beeing sarcastic. This is another example of the wrong answer getting the points. I'm all for giving a hint instead of a solution, but that wont earn any points. Too bad.

arnvig>OK, I thought you were commenting me NOT giving a direct solution. I dont mind too much about mugs getting the points (he needs them :o) ) But in this case its the wrong (incomplete) solution.