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

On a report or in a query?

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;

Thanks Pat, worked fine