Count Fields (2 Viewers)

[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?

 

[Pat Hartman]

You can do this in a report by suppressing the detail lines and just showing the group footers or in a query.

query:
Select t1.Company, t2.AircraftType, Count(*) As CountOfAircraft
From Company as t1 Inner Join Fleet as t2 on t1.Company = t2.Company
Group by t1.Company, t2.AircraftType;

 

[Anauz]

Thanks Pat, worked fine