Recent content by bwarren

Yes, I would agree I think GROUP BY has too many fields. When I did not have QuantityCases and LBsPerCase in that section, I was getting an error saying the formula that included them were not part of an aggregate function. In query design, I just checked them to not 'show'. I thought that...

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...

I ask if it is feasible because I have looked on a number of forums for similar projects with a lot of responses saying that the project is too large, or that there are third-party ERP systems that can more easily handle the situation. I also have not set up any of the tables yet because I do...

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...