Thx all, maybe someone has better eyes than I do. I am receiving a syntax error in FROM clause statements for this SQL statement,
SELECT qry.SelectionRowID_FK, Sum(qry.QtyToSell) AS Qty, ItemsTABLE.StoreDepartment
FROM (SELECT ProductInventoryTABLE.SelectionRowID_FK...