question|count table

[mikichi]

hi,
i have a table with 3 column:

name	proffesion
daniel	police man
josh	teacher
michael	police man

how i can to create a query that count how much people in each proffesion.
in my exemple the wuery return:


police man - 2
teacher - 1
thank you,
miki

[JoeM]

Create a Aggregate Query.
Add these two fields to a new query.
Click on the Totals icon (looks like a Sigma) to create an Aggregate Query.
A new "Totals" row is added in Query Builder view. Under each field, the value will be "Group By".
Change the Totals row value under the "name" field from "Group By" to "Count".
View the results.

[mikichi]

thank you very much!!