Duplicate Recordes Count

[shaanii]

Hi Guyz

I Have Data In 4 Colums And I Wanna Sort And Count Duplicate Recordes
For Example
Id Numbers Total Trade
A 123 16
B 876 19
C 976 20
D 324 12
A 123 44
B 876 34
A 123 11

I Just Wanna To Count Id And Numbers Column Like How Many Time A Use 123 Numbers Hope U Understand My Problem I M New In Access Dont Know How To Make Query

Quick Reply Will Appericiate

 

[ajetrumpet]

Id Numbers Total Trade
A 123 16
B 876 19
C 976 20
D 324 12
A 123 44
B 876 34
A 123 11

I Just Wanna To Count Id And Numbers Column Like How Many Time A Use 123 Numbers

Use this code to find the number of duplicate records for each combination of ID & Numbers:

SELECT table.ID, table.Numbers, COUNT(table.ID)

  FROM table

    GROUP BY table.ID, table.Numbers

      HAVING COUNT(table.ID) > 1 AND Count(table.Numbers) > 1;

 

[neileg]

Don't post the same question in more than one forum, please.