AlexTeslin
Registered User.
- Local time
- Yesterday, 17:55
- Joined
- Jul 10, 2008
- Messages
- 55
Hi, I searched all the mails with this subject, but still do not have a difinate answer. I would like to eliminate duplicates within a field in a query with other fields been distinct. So for example:
Col1 Col2 Col3
ref1 val1 val2
ref2 val10 val11
ref2 val5 val11
ref3 val20 val21
As you can see, I have ref2 twice in Col1 (which is a primary key on the original table). I have used DISTINCT, but it only eliminates entire duplicate records. I know I can leave only Col1 field and DISTINCT will do the job, but I would like to keep all my fields. Also, by using COUNT I can eliminate them, but I am getting the number of duplicates say in Col2 and hence the values of a column dissappears.
Is there a way round this?
I am using Access 2003.
Any suggestions will be appreciated,
Thank you
Col1 Col2 Col3
ref1 val1 val2
ref2 val10 val11
ref2 val5 val11
ref3 val20 val21
As you can see, I have ref2 twice in Col1 (which is a primary key on the original table). I have used DISTINCT, but it only eliminates entire duplicate records. I know I can leave only Col1 field and DISTINCT will do the job, but I would like to keep all my fields. Also, by using COUNT I can eliminate them, but I am getting the number of duplicates say in Col2 and hence the values of a column dissappears.
Is there a way round this?
I am using Access 2003.
Any suggestions will be appreciated,
Thank you