If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query repeated values
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. |
#2
|
|||
|
|||
Query repeated values
Use the "Find Duplicates" query wizard to construct a query.
-TedMi "Jose Lopes" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|