DETECTIVE COMICE 1000 VARIANTS

[mark d. smith]

a lot of the detective 1000 issues are listed with same numbers e.g detevective comics 1000/v4

[mark d. smith]

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

[Steven L. Dasinger]

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

 

[mark d. smith]

The issue was I dragged the column too far lol so completely my fault