Hi Guy's
I am trying to create a chart report to show OS Version Numbers.
I have the following, but I can't get the first numbers listed first to show the Version Numbers and the count afterwards which is what I believe is required for the chart.
At present it displays the count numbers first so on the Chart that is what its filted by.
Select Top 1000000 Count(tblAssets.AssetID) As Total,
tblAssets.Version As Version
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Group By tblAssets.Version,
tsysOS.OSname
Order By Total Desc