Thanks for your quick reply, but I am not completely following you. This is the command that I have -
SELECT RX.RX_Site_Code, RX.RX_Drug_Name, Sum(RX.RX_Qty) AS SumOfRX_Qty, Sum(RX.RX_Price) AS SumOfRX_Price
FROM Site INNER JOIN RX ON Site.Site_Code = RX.RX_Site_Code
WHERE (((RX.RX_Date) Between #7/1/2005# And #6/30/2006#) AND ((Site.Site_Roll_Up_Region)="new mexico"))
GROUP BY RX.RX_Site_Code, RX.RX_Drug_Name
ORDER BY Sum(RX.RX_Qty) DESC;
It imports the records the way I need (so I can only show the top 25), but I still cannot figure out how to have the drug names sorted alphabetically, but only showing the top 25 by quantity.