Help me calculate standard deviation for more than one record at a time 1

[keun]

When I do what I think should work, I get an error:

You tried to execute a query that does not include the specified expression "MealID"

SELECT tblMealDetail.name, StDev([SumOfqty]) AS StDev
FROM tblMealDetail;

This is what my data looks like:

"name" "MealID""SumOfqty"
"abe" "A001" 9.00
"abe" "A002" 10.00
"abe" "A003" 8.00
"jen" "A004" 8.00
"jen" "A005" 6.00
"jen" "A006" 9.00
"lisa" "A007" 7.00
"lisa" "A008" 7.00
"lisa" "A009" 7.00
"mike" "A010" 6.00
"mike" "A011" 8.00

If I filter the source to just one "name" I can run the stDev but I cannot get the stDev for each "name" all in one shot.

I joined this forum in 2005. I am still a hack.

 

[dhookom]

Try this SQL:

SELECT tblMealDetail.name, StDev([SumOfqty]) AS StDev
FROM tblMealDetail
GROUP BY tblMealDetail.name;

Duane
Hook'D on Access
MS Access MVP

 

[keun]

That's it! Very interesting and thanks!

I joined this forum in 2005. I am still a hack.