removing duplicate rows from access table

[dan graziano]

Hi,

How do you suggest is the best way to check for duplicate rows in an
access table. And once one knows if there are duplicates, to remove all
but one.

In my access table, there are 5 field columns. The first 4 columns are
descriptor fields. The 5th column is a value.

You know there are duplicate rows when the contents of the first four
columns are exactly the same in more than one of the rows of the table.

Thanks, and looking forward to your suggestions.

Dan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tom van Stiphout]

On 14 Oct 2004 22:28:44 GMT, dan graziano <d3********@hotmail.com>
wrote:

All but one? Which one?
You could do something like:
select Descriptor1, D2, D3, D4, Max(ValueField) from MyTable
Group by Descriptor1, D2, D3, D4

-Tom.

Hi,

How do you suggest is the best way to check for duplicate rows in an
access table. And once one knows if there are duplicates, to remove all
but one.

In my access table, there are 5 field columns. The first 4 columns are
descriptor fields. The 5th column is a value.

You know there are duplicate rows when the contents of the first four
columns are exactly the same in more than one of the rows of the table.

Thanks, and looking forward to your suggestions.

Dan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[dan graziano]

Tom,

Thanks for the suggestion. They should all be the same, so it shouldn't
matter which one or ones are deleted as long as there is one remaining.
How would you complete the code if that was the situation? Thanks.

Dan
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tom van Stiphout]

On 15 Oct 2004 12:58:37 GMT, dan graziano <d3********@hotmail.com>
wrote:

You could turn my suggested SQL Statement into a MakeTable query,
which would create a new table. If you're happy with the data, you can
delete the original table.

-Tom.

Tom,

Thanks for the suggestion. They should all be the same, so it shouldn't
matter which one or ones are deleted as long as there is one remaining.
How would you complete the code if that was the situation? Thanks.

Dan
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!