Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. James2020

    Counting duplicates within combinations of groups

    Thanks r937, I have managed to solve part 2 of the problem. Just in case anyone else is interested, my solution to part 2 uses two SQL statements... Make_B: SELECT CD AS CD_B, Track AS Track_B FROM MyTable; Joiner: SELECT CD, CD_B, Count(Track) AS CountOfDuplicates FROM...
  2. James2020

    Counting duplicates within combinations of groups

    Hi All, I have a database table which contains approx 20,000 records in the following format: Disk Track ===================== CD1 Unique to CD1 CD1 On all three CD1 On CD1 and CD2 CD1 On CD1 and CD3 CD2 Unique to CD2 CD2 On all three...

Part and Inventory Search

Back
Top