Summing Totals in Query

[DerekDaNoob]

I am having trouble summing totals on a query

I need to group by IngredientID and have the total for that ingredient added up. Then sorted highest to lowest

 

[Ranman256]

Show us the SQL
You have something in the query that is wrong.

 

[DerekDaNoob]

Thanks for the reply

SELECT [Meal - Recipes IngredientListQ].MealID, [Meal - Recipes IngredientListQ].IngredientID, [Meal - Recipes IngredientListQ].IngredientName, Sum([Meal - Recipes IngredientListQ].Qty) AS SumOfQty
FROM [Meal - Recipes IngredientListQ]
GROUP BY [Meal - Recipes IngredientListQ].MealID, [Meal - Recipes IngredientListQ].IngredientID, [Meal - Recipes IngredientListQ].IngredientName, [Meal - Recipes IngredientListQ].ID
ORDER BY [Meal - Recipes IngredientListQ].IngredientName, Sum([Meal - Recipes IngredientListQ].Qty) DESC;

 

[plog]

Demonstrate your issue with data please. Provide 2 sets of data:

A: starting data from your table(s). Include table and field names and enough data to cover all cases.

B. expected results from A. Show what you expect to end up with when you feed in the data from A.

 

[Ranman256]

Remove the
GROUP BY [Meal - Recipes IngredientListQ].ID

you dont want to group this. ID shouldnt be in the query.

 

[almahmood]

Try this:

SELECT [Meal - Recipes IngredientListQ].MealID, [Meal - Recipes IngredientListQ].IngredientID, [Meal - Recipes IngredientListQ].IngredientName, Sum([Meal - Recipes IngredientListQ].Qty) AS SumOfQty
FROM [Meal - Recipes IngredientListQ]
GROUP BY [Meal - Recipes IngredientListQ].MealID, [Meal - Recipes IngredientListQ].IngredientID, [Meal - Recipes IngredientListQ].IngredientName
ORDER BY [Meal - Recipes IngredientListQ].IngredientName, Sum([Meal - Recipes IngredientListQ].Qty) DESC;