Find duplicates in query with query

[Guest]

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

 

[ChrisHulan]

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

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

 

[Guest]

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

 

[Peter Hibbs]

Chad

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

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

may be of interest.

Peter Hibbs.

 

[Guest]

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

-Chad

 

[Guest]

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

 

[Peter Hibbs]

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