Hello again. I have the following query:
SELECT tblProductInfo.strItemNumber, tblProductInfo.strDescription, [Units]*[lngAmtPerCase] AS [Total Units]
FROM tblProductInfo INNER JOIN tblLastYearSales ON tblProductInfo.strItemNumber = tblLastYearSales.[Item #];
I'd like to add a Rank column that will rank the items. The item that has the most [Total Units] would be ranked 1, and descending from there. I've tried a couple of things, but I obviously didn't do it right. I thought it would be pretty easy, but I couldn't figure it out (doesn't mean it's not easy).