How do I Find Count of Matching Items

[artemetis]

Hey there!

I have a table with tool sizes.

table: tblTool1
field: tl1Size

tlSize contains the following info: small, medium, large
There are thousands of tools and I need to run a query to get a count of how many small, medium, and large tools there are.

Never did a "count" before.

[Rabbit]

select count(*) as countofsize, size
from someTable
group by size

[artemetis]

AWESOME!

Worked like a charm!!
Thanks, Rabbit!~