>Here's some SQL for MS SQL Server (you're not using Access are you?):
Dude, works like a champ! You rock! I changed it to top 5 and added a little more pizazz. My quesion is, why is the order by like that? What is 2? I've only seen it done by field names. SELECT TOP 5 prodName + ' ' + merchSKUID AS itemsold, sum(prodQty) as totalordered FROM tblOrderItems GROUP BY prodName, merchSKUID ORDER BY 2 desc Thanks much! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250811 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
