triplell89
Registered User.
- Local time
- Yesterday, 18:29
- Joined
- May 21, 2009
- Messages
- 21
Hi,
I'm trying to create a query that will search through my table and return any rows that have matching fields in a different row of that same table. (or partial matching fields is my final goal, however obtaining the query is my first objective)
Here is an example Table
John Smith 842
Jan Smith 333
Joe Smith 434
June Smith 842
Jack Smith 333
Here is what I want as the result:
John Smith 842
June Smith 842
Jan Smith 333
Jack Smith 333
I know I can create some VBA for excel that could do this, but I would like to learn how to do this purely in access.
Thanks
I'm trying to create a query that will search through my table and return any rows that have matching fields in a different row of that same table. (or partial matching fields is my final goal, however obtaining the query is my first objective)
Here is an example Table
John Smith 842
Jan Smith 333
Joe Smith 434
June Smith 842
Jack Smith 333
Here is what I want as the result:
John Smith 842
June Smith 842
Jan Smith 333
Jack Smith 333
I know I can create some VBA for excel that could do this, but I would like to learn how to do this purely in access.
Thanks