I am working on a query that I just can't get to work the way I need. I have written the following query that identifies subject names (subjectName) that exist more than once in the table:
GROUP BY multipleSubjectNameQry.subjectName
But I need this query to also display the record number (primary key). But, when I add the primary key field the query doesn't return anything because the results are no longer duplicates. How can I modify this query so that it provides the list of subject names that exist more than once, along with their record numbers?
Any help would be greatly appreciated. I am working with MS Access 2013 on Windows 7.
Also, I have tried the following, but it doesn't work either:
SELECT multipleSubjectNameQry.subjectName, multipleSubjectNameQry.myID
GROUP BY multipleSubjectNameQry.subjectName, multipleSubjectNameQry.myID