Query duplicated entries

[Jose Lopes]

Hello everyone. Sorry for such a newbie doubt, but since my Access and SQL
experience is a bit “trial and error†I don’t even know what to search for
here in the forums that so I can help myself.

I have two tables A and B.

First table has people’s NAMES field.
Marc Wilson
Andrea Smart
Francis Junior

Second table has a field with people’s ABILITIES but some are repeated:
WORD – Marc Wilson
WORD – Andrea Smart
EXCEL – Francis Junior
COREL – Andrea Smart
COREL – Andrea Smart

I’m trying to build a query to point out the duplicated lines, in this case:
COREL – Andrea Smart

Thx in advance.

 

[vanderghast]

Make a total query, GROUP on the fields which define the 'uniqueness',
COUNT(*) the records, those groups HAVING COUNT(*) > 1 imply that the
group own more than one record (so, there is dup):


SELECT names, abilities
FROM secondTable
GROUP BY names, abilities
HAVING COUNT(*) > 1



should thus do.


Vanderghast, Access MVP