Assets Summary SELECT COUNT(tbl_VersaAssets.AssetID) AS AssetCount, tbl_VersaAssetTypes.AssetType, tbl_VersaAssets.BOrg1, tbl_VersaAssets.BLocation, tbl_VersaAssets.BOrg2 FROM tbl_VersaAssets LEFT OUTER JOIN tbl_VersaAssetTypes ON tbl_VersaAssets.AssetTypeID = tbl_VersaAssetTypes.AssetTypeID GROUP BY tbl_VersaAssetTypes.AssetType, tbl_VersaAssets.BOrg1, tbl_VersaAssets.BLocation, tbl_VersaAssets.BOrg2 ORDER BY tbl_VersaAssetTypes.AssetType, tbl_VersaAssets.BOrg1, tbl_VersaAssets.BLocation, tbl_VersaAssets.BOrg2 No. of Assets Asset Type Division Portfolio Business Unit