Report by model per department

[faccount]

Hi,

i need a report that will display the number of computer models per department so like


Marketing -> HP 7100 (26)
HP 7600 (43)

Finance -> Hp 7100 (12)
HP 7600 (17)



Etc.


maybe even better if possible break it down by like

Marketing -> HP (69) then when you click on the hp it breaks down the individual models and number of those models.


Thanks for any help

[Hemoco]

try this:

Select top 1000000 tblCompCustom.Department, tblComputerSystemProduct.Vendor,
  tblComputerSystemProduct.Name, Count(tblComputers.Computername) As Total
From tblComputers Left Join
  tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
  Inner Join
  tblComputerSystemProduct On tblComputers.Computername =
    tblComputerSystemProduct.Computername
Group By tblCompCustom.Department, tblComputerSystemProduct.Vendor,
  tblComputerSystemProduct.Name
Order By tblCompCustom.Department, tblComputerSystemProduct.Vendor,
  tblComputerSystemProduct.Name