De Duplicate Query

[Guest]

Hello,
In the Table I have 3 col.
ID Name Country
1 Boston Bank USA
2 Boston Bank Canada
3 Boston Bank Paris
ID is the unique value of the Table.

I need to run a querry to extract :Give all records where "Name" is the same
and "Country" is diferent.
Can someone help me on this?

Thank you
Bob

 

[Keith Leslein]

You can set up a standard select query and set the query properties
Unique Values option to yes. This will show you all listings with
distinct values. It may show you multiple values if the Bank Name is
the same and in a different country or region as this will be a unique
entry. This sounds like what you are looking for based off the
information provided.

 

[John Spencer]

Do you have records that repeat the value? That is with your limited set,
might you have
21 Boston Bank USA

Or must the combination of Name and Country be unique?

If the combination is unique, then all you really need is
SELECT *
FROM YourTable
WHERE Name IN
(SELECT [Name] FROM YourTable GROUP BY [Name] HAVING Count([Name])>1)

If the combination is not unique then you have to get a distinct list first.
With your naming scheme and Access this will probably mean a stacked query
solution.

QueryOne
SELECT Distinct [Name] as TheName, Country
FROM YourTable

SELECT *
FROM YourTable
WHERE Name IN
(SELECT TheName FROM QueryONE GROUP BY TheName HAVING Count(TheName)>1)