group by / count

[bonusgeezer]

my table looks like this

F1 A1
F1 A1
F1 A2
F1 A3
F2 A1
F2 A1
F3 A1
F3 A2
F3 A3

i want a query like this

F1 A1 2
F1 A2 1
F1 A3 1
F2 A1 2

etc etc etc

and i just gone blank

thanks in advance people

 

[tlbroadbent]

Select col1, col2, count(*) As RecCnt
From table
Group By col1, col2 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.