I have a table with a list of people ([FirstName], [Surname], [Age]). Some of these people are in the same family. I'd like to return a list of people who have another family member in the table (same surname). However I'd like to exclude records that have no other records with the same surname. Whats the best way to do this in MS Access
Ms-access – Access query to select multiple records with matching field
ms access
Related Question
- Ms-access – Removing duplicates from a query with conditions in Access 2007
- SQL Server – Access Write Conflicts with Views and InsteadOf Triggers
- Beginner’s Guide to Access Many-to-Many Relationships
- Ms-access – Simple access query based on many to many relationship
- MS Access – Exclude Records with More Than Requested Values in M:N Relationship Query
- Ms-access – Access query to locate changed records
- Ms-access – Find rows without matching second field for given constants in first field
Best Answer
OR