mark d. smith Posted October 23 Share Posted October 23 a lot of the detective 1000 issues are listed with same numbers e.g detevective comics 1000/v4 Link to comment Share on other sites More sharing options...
mark d. smith Posted October 23 Author Share Posted October 23 7 minutes ago, mark d. smith said: a lot of the detective 1000 issues are listed with same numbers e.g detevective comics 1000/v4 solved,but cant seem to remove this thread Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted October 23 Share Posted October 23 Can you post the solution? PS This Advanced Find can display issues that are duplicates based in Title, and Item # : Items Where: I.Title || I.IssueNum || I.ItemType || I.Variation || I.Printing IN ( SELECT A.Title || A.IssueNum || A.ItemType || A.Variation || A.Printing FROM ComicIssues A WHERE I.Title = A.Title AND I.IssueNum = A.IssueNum AND I.ItemType = A.ItemType AND I.Variation = A.Variation AND I.Printing = A.Printing GROUP BY A.Title, A.IssueNum, A.ItemType, A.Variation, A.Printing (add ,I.Condition) HAVING COUNT(*) > 1 ) Order By: ComicTitles.AlphabetizedTitle, I.ItemType, I.IssueNum, I.Variation, I.Printing If you have Multiple issues with different Conditions: I.Title || I.IssueNum || I.ItemType || I.Variation || I.Printing || I.Condition IN ( SELECT A.Title || A.IssueNum || A.ItemType || A.Variation || A.Printing || A.Condition FROM ComicIssues A WHERE I.Title = A.Title AND I.IssueNum = A.IssueNum AND I.ItemType = A.ItemType AND I.Variation = A.Variation AND I.Printing = A.Printing AND I.Condition = A.Condition GROUP BY A.Title, A.IssueNum, A.ItemType, A.Variation, A.Printing, A.Condition HAVING COUNT(*) > 1 ) Order By: ComicTitles.AlphabetizedTitle, I.ItemType, I.IssueNum, I.Variation, I.Printing 1 Link to comment Share on other sites More sharing options...
mark d. smith Posted October 23 Author Share Posted October 23 The issue was I dragged the column too far lol so completely my fault Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now