Summing Rows/coloumns in table with unique values

S

souchie40

I'm havbing a complete mind F**T on this one so can any one plaese help I'm
trying to develop a DB which as a top level item that can have loads of
combinations of lower level items what I need todo is add the number of
unique lower level items together so that I can work out a cost and number of
items for a business case.
 
S

souchie40

Sorry here is an example of what I want to do:
The table contains the following fields

Ship ID
Ship Name
Propulsion Arrangement
Gas Turbine Type
Number Of GTs
Diesel Type
Number Of Diesels

and so on the Gas Turbine and Diesel type's are selected from linked tables
but there are many different types of each, so each ship can have numerous
permtations, so what I would like to do is run a Query of some sort that can
return me the total number of each type of diesel and Gas Turbine.

Hope this makes it clearer

Many thanks in advance
 
Top