data sorting and count

[shaanii]

hi dear members
i m new in access dont know how make query i wanna sort and count duplicate recorde with the help of query
for example
id numbers total numbers of trade
A 123 98674
B 456 98458
C 674 093253
A 123 84545
A 123 3423

I JUST WANNA COUNT "ID" AND "NUMBERS" COLIMN HOW MANY TIME A USE 123 NUMBERS HOPE U UNDERSTAND MY PROBLEM PLZ LET ME KNOW HOW I SORTED OUT THIS PROBLEM

HELP APPERICIATED

 

[neileg]

You need an aggregate query that groups by ID and Numbers and either sums [Total numbers of trades] or counts them depending on what you want. Look in Access help for aggregate or totals queries.