Code:
SELECT qryTerSales.SumOfSales, qryTerSales.TerritoryID, qryTerSales.TerNameID, tblTerritories.Territory, tblTerName.TerName

FROM (
(SELECT top 5 tblTerSales.TerritoryID, tblTerSales.TerNameID, Sum(tblTerSales.Sales) AS SumOfSales
FROM tblTerSales
GROUP BY tblTerSales.TerritoryID, tblTerSales.TerNameID
order by Sum(tblTerSales.Sales)
) AS qryTerSales 
LEFT JOIN tblTerName ON qryTerSales.TerNameID = tblTerName.TerNameID) 
LEFT JOIN tblTerritories ON qryTerSales.TerritoryID = tblTerritories.TerritoryID

GROUP BY qryTerSales.SumOfSales, qryTerSales.TerritoryID, qryTerSales.TerNameID, tblTerritories.Territory, tblTerName.TerName
ORDER BY tblTerritories.Territory;
Something like that (made up of relative tables...


Vince