Search results

  1. B

    Help with SQL Inventory query

    SELECT [Order Details].ProductID, Sum([Order Details].QuantityCases) AS QOH, Inventory.LBsPerCase*[Order Details].QuantityCases AS totWeight, Inventory.IngredientName FROM Inventory INNER JOIN [Order Details] ON Inventory.ProductID = [Order Details].ProductID GROUP BY [Order Details].ProductID...
  2. B

    Food Manufacturing Lot Number Tracking Database

    I've spent a while looking at other forums trying to figure out the problem I am having with building a MS Access Database for tracking a lot number through manufacturing from the Raw Materials Inventory to Finished Goods. I have a pretty solid background of MS Access concepts and some...
Top Bottom