Hi JacobH,
I made the change you advised and I do beleive its the answer. Here is the code and ScreenShot as requested
thank you ever so much. So obvious, that i couldnt see for looking
Select Top 1000000 tsysOS.OSname,
Count(tblAssets.AssetID) As Total,
tblADComputers.OU,
tblOperatingsystem.Caption
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Where tsysOS.OSname Like '%Win 10%' And tblADComputers.OU Like '%GP%' And
tsysIPLocations.IPLocation Not Like '%CRH - IT Build VLAN%' And
tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Group By tsysOS.OSname,
tblADComputers.OU,
tblOperatingsystem.Caption,
tsysIPLocations.IPLocation
Order By Total Desc