This is really great however I thought it was supposed to take the most
unique record to the new table. I am trying to do this same thing as I have
duplicates in my table however only one record out of each of the duplicates
has data entered into a certain field I need. When I run the append query I
am getting some records that has blank data in those fields instead. Is
there anyway to specifiy which duplicates it should remove when doing the
append query? Thanks,

"Guest" wrote:

Thank you, ive been trying to do this all day!!!

"Raghu Prakash" wrote:

Hi Alice,

Finding and deleting duplicate records in Access:
To delete duplicate records and keep the originals automatically
Deleting duplicate records from a table requires two steps. First, you
create a copy of the structure of the table that contains duplicates and
make primary keys of all the fields that contain duplicates. Second, you
create and run an append query from the original table to the new table.
Because fields that are primary keys can't contain duplicate records, this
procedure produces a table without duplicate records.

To copy the table and make primary keys of fields with duplicates
Select the table in the Database window.
Click Copy on the toolbar.
Click Paste on the toolbar.
In the Paste Table As dialog box, type a name for the copied table, click
Structure Only, and then click OK.
Open the new table in Design view, and select the fields that contained
duplicates in the table you copied.
Click Primary Key on the toolbar to create a primary key based on the
selected fields.
Save and close the table.
To append only unique records to the new table
Create a new query based on the original table that contains duplicates.
In Query Design view, click Query Type on the toolbar and then click Append
Query.
In the Append dialog box, click the name of the new table in the Table Name
list and then click OK.
Include all the fields from the original table by dragging the asterisk (*)
to the query design grid.
Click Run on the toolbar.
Click Yes when you receive the message that you are about to append rows.
Click Yes when you receive the message that Microsoft Access can't append
all the records in the append query. This transfers only unique records to
your new table and discards the duplicates.
Open the table to see the results. When you're sure the new table has the
correct unique records, you can delete the original table and then rename
the new table with the name of the original table.

For Further Information :
http://office.microsoft.com/assistan...010345581033&C
TT=1&Origin=EC010227041033&QueryID=qUf5qLZCA0

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.