a little duplicate problem...

[ElastoManiac]

So this is a very basic question, listen up:
I have only one table in my database. The table contains several text fields ( about 8 ).
The table is filled with very very much data. The problem is that i have a multiple
instances of the same data ( i mean apsolutly same, all the fields are same ) so
i need to delete copies.
Help please. Those copies are making me mad

 

[ghudson]

The Access query wizard has a built-in "Find Duplicates" query wizard option.

You need to setup some primary keys in your table to prevent duplicate records from being saved to your table.

 

[ElastoManiac]

does 2000 version has the wizard, and how to run it?

 

[ghudson]

Select the Queries object in the database window, click the New button, select the Find Duplicates Query Wizard, click the OK button and follow the wizard prompts.

 

[ElastoManiac]

thanks!!!!!!