Find duplicates in query with query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chad - 23 Mar 2007 16:14 GMT

I've got a query and I am trying to find and remove duplicates from it with
another query. I used the wizard to do it, but its not working properly.
Any thoughts on how I can make it work properly. My initial query has 2
columns of data (player 1 and player 2) and I'd like to remove duplicate
names for each set of players.

Thanks in advance,
-Chad

Reply to this Message

ChrisHulan - 23 Mar 2007 17:51 GMT

> I've got a query and I am trying to find and remove duplicates from it with
> another query. I used the wizard to do it, but its not working properly.
[quoted text clipped - 4 lines]
> Thanks in advance,
> -Chad

If you have:
playerA, playerB
playerB,playerC
playerA,playerB <==a duplpicate

you can see the unique records by adding the DISTINCT clause to the
original query, no need for a second. You can type it in the SQL view
of the query, or in the design view right click and select
Properties. In the Query Porperties set Unique Values to Yes.

Cheers

Reply to this Message

Chad - 23 Mar 2007 18:14 GMT

I appreciate your response. Perhaps I wasn't specific enough. I have
information such as the following:

PlayerA,playerB
playerD, playerD
playerA,playerD

In this case, I am wanting to get rid of the last line: playerA,playerD, as
these are duplicates. Any additional thoughts?

Thanks,
-Chad

> > I've got a query and I am trying to find and remove duplicates from it with
> > another query. I used the wizard to do it, but its not working properly.
[quoted text clipped - 15 lines]
>
> Cheers

Reply to this Message

Peter Hibbs - 23 Mar 2007 23:15 GMT

Chad

It may not be quite what you are looking for but the demo code at :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Fixtures_Genera
tor.mdb'

may be of interest.

Peter Hibbs.

>I appreciate your response. Perhaps I wasn't specific enough. I have
>information such as the following:
[quoted text clipped - 28 lines]
>>
>> Cheers

Reply to this Message

Chad - 28 Mar 2007 02:12 GMT

I'm getting an error when I follow this link. Any thoughts?

-Chad

> Chad
>
[quoted text clipped - 38 lines]
> >>
> >> Cheers

Reply to this Message

Chad - 28 Mar 2007 02:57 GMT

I was able to find the demo to which you directed me. I appreciate your
efforts on this. I am having some trouble viewing the demo's output, as it
gives me errors when I try to utilize the file. It opens properly, but when
I try to allocate the fixtures, it says "Operation must use an updateable
query." Any additional help is appreciated.

Thank you,
-Chad

> Chad
>
[quoted text clipped - 38 lines]
> >>
> >> Cheers

Reply to this Message

Peter Hibbs - 28 Mar 2007 14:05 GMT

Hi Chad

I have no idea why it doesn't work, I have just downloaded it from the
Web site and it runs OK.

What version of Access are you running it on.

I suppose it might be something to do with the DAO 3.6 Object Library,
have you checked whether that reference is ticked. My copy of the
dao360.dll file is version 3.60.8618.0.

Other than that I don't know what else to suggest (unless anyone else
has any ideas).

Peter Hibbs

>I was able to find the demo to which you directed me. I appreciate your
>efforts on this. I am having some trouble viewing the demo's output, as it
[quoted text clipped - 47 lines]
>> >>
>> >> Cheers

Reply to this Message