Beginner- how to count field per another field

[Wena]

Hi
I am trying to assist my son with his homework and I am battling a bit.
We have a table with (amongts others) owner and brand.
each owner has multiple brands in the table.

How do I count the the brands per owner.
When I use count(brands) with out owner I get the total amount of brands but I can not get the total amont of brands per owner.



Thanks

Alistair

[Wena]

It must be in a query format.
select Owner, count(brand)
from tblMyTable

[alansidman]

Look at aggregate queries.

http://www.techonthenet.com/access/queries/index.php

Scroll down in this link to group by queries.