That did the trick! Thanks!!!
I now have a total quantity of what was sold, a total price of the quantity sold and a price of the quantity still available for a specific date range.
Here is what the final query looks like:
SELECT inventory.itemId, inventory.itemName, inventory.itemDesc, inventory.itemPrice, inventory.itemQty, inventory.itemSize, inventory.itemColor, inventory.partNum, inventory.prodLine, orders.OrderDate, orderdetails.DetailItemId, orderdetails.DetailQuantity, (inventory.itemQty*inventory.itemPrice)AS InventoryTotal, SUM(orderdetails.DetailQuantity*inventory.itemPrice)AS TotalUsed, SUM(orderdetails.DetailQuantity)AS OrderUsed
FROM orderdetails INNER JOIN inventory ON orderdetails.DetailItemId = inventory.itemId INNER JOIN orders ON orderdetails.DetailOrderId = orders.OrderId
GROUP BY inventory.itemId
ORDER BY inventory.itemName ASC