removing duplicates from query results

[rsi]

I know access has the Uniqe values and Unique records options when you
create a query but neither really help me. I need to remove rows depending
on whether or not certain combinations of fields are unique. If there is
any way to do this i really need to know. thanks.

joe

 

[rsi]

to add to this, i need to remove all rows that are duplicates except for one
(my results are being returned more than once).

joe

 

[Alick [MSFT]]

Whether or not certain combinations of fields are unique should be better
based on the design, if so, you may try query or ADO RecordSet to loop and
delete the duplicated ones.



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.


--------------------
| From: "rsi" <none>
| Newsgroups: microsoft.public.access.queries
|
| I know access has the Uniqe values and Unique records options when you
| create a query but neither really help me. I need to remove rows
depending
| on whether or not certain combinations of fields are unique. If there is
| any way to do this i really need to know. thanks.
|
| joe
|
|
|