SQL Distinct records

[FengShui1998]

Hello,

I am trying to total the number of distinct records in a table. For example, I have a field called ActionType and there are about 30 records. I can query "SELECT Distinct ActionType from TableA", this produces about six distinct types. But I actually want to find out how many of records of each distinct type I have.

Any ideas?

Your help is greatly appreciated.
Thanks,
fengshui1998

 

[RobertT687]

Try:

Select ActionType, Count(ActionType) As OnHand FROM TableA
Group By ActionType, Order By ActionType