Chart Report for Approved / Denied / Unclassified software

[ryancarter]

I am trying to build a report that will work with a chart to show me Approved / Denied / Unclassified software.

[ryancarter · Accepted solution]

I did it like this:

Select Top 1000000 Case tblSoftwareUni.Approved When 1 Then 'Approved'
When 2 Then 'Denied' Else 'Unclassified' End As Status,
COUNT(*) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Group By Case tblSoftwareUni.Approved When 1 Then 'Approved'
When 2 Then 'Denied' Else 'Unclassified' End