Query repeated values

[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.

 

[TedMi]

Use the "Find Duplicates" query wizard to construct a query.
-TedMi