eliminating duplicate rows in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have an access table with 200,000 rows of three column data (see snippet
below):

Field1 Field2 Field3
213543 5 05.0102
213543 5 05.0102
213543 5 05.0103
213543 5 05.0103
213543 5 05.0201
213543 5 09.0401
213543 5 09.0401

I want to elimate any complete duplicate rows. so using the above example,
I'd like the output to look like:

Field1 Field2 Field3
213543 5 05.0102
213543 5 05.0103
213543 5 05.0201
213543 5 09.0401

Basically, i want the rows to only appear once, and in some cases i've got
exact identical rows.
 
Hello,

I have an access table with 200,000 rows of three column data (see snippet
below):

Field1 Field2 Field3
213543 5 05.0102
213543 5 05.0102
213543 5 05.0103
213543 5 05.0103
213543 5 05.0201
213543 5 09.0401
213543 5 09.0401

I want to elimate any complete duplicate rows. so using the above example,
I'd like the output to look like:

Field1 Field2 Field3
213543 5 05.0102
213543 5 05.0103
213543 5 05.0201
213543 5 09.0401

Basically, i want the rows to only appear once, and in some cases i've got
exact identical rows.
Click to expand...

The simplest way to do this is to create a new, empty table; use its
Indexes tool (the lightning bolt hitting a datasheet icon) to create a
unique three-field Index. Name the index whatever you like in the left
column and select all three columns; check the Unique checkbox.

Then run an Append query to move the data from your table with
duplicates into this new table. You'll get a warning message "xxx
records were not added due to key violations" - those are the
duplicates disappearing.

John W. Vinson[MVP]
 
Back
Top