I have a query that captures count of OS by Department. My issue is that I cannot make the count of assets to show me which assets within the department has the specific OS. In other words I am unable to make the count as links to produce the data I need. Below is the query. Any assistance is appreciated.
Select Top 1000000 tblAssetCustom.Department,
tblOperatingsystem.Caption As OS,
Count(tblAssets.AssetID) As Number
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssetCustom.State = 1
Group By tblAssetCustom.Department,
tblOperatingsystem.Caption
Order By tblAssetCustom.Department,
OS
