SELECT 0000000000+SUM(NVL(WeekShips.Shipped,0)) AS nShipped, ; 0000000000+SUM(NVL(WeekSales.Sales,0)) AS WeekSales, ; 0000000000+SUM(NVL(YTDSales.Sales,0)) AS YTDSales, ; ItemSetup.Retail, 0000000000+NVL(iciwhs.nOnHand,0) AS nOnHand ; FROM ItemSetup ; INNER JOIN ItemSales ON ItemSetup.cItemNo = ItemSales.cItemNo ; AND ItemSales.Category = "TRANSFER" ; LEFT JOIN WeekShips ON WeekShips.cItemNo = ItemSetup.cItemNo ; LEFT JOIN WeekSales ON WeekSales.UnitRetail = ItemSetup.Retail ; LEFT JOIN IciWhs ON iciWhs.cItemNo = ItemSetup.cItemNo ; LEFT JOIN YTDSales ON YTDSales.UnitRetail = ItemSetup.Retail ; ORDER BY ItemSetup.Retail, nOnHand ; GROUP BY ItemSetup.Retail, nOnHand ; HAVING YTDSales > 0 ; INTO CURSOR SpreadsheetResultsMy resulting cursor has many records for each "retail" value! Any idea why?