Count Fields

[Anauz]

Hi All

Desperately need some help.

I have two tables Company(t1), Fleet(t2)
Each company can have n aircrafts.
What i want to do is count and total the different types of aircraft each Company has.....can anyone help?


Thanx in advance

 

[Rich]

On a report or in a query?

 

[Anauz]

Thanks Pat, worked fine