Just when I thought I was getting good at this...<br>I want the average and standard deviation of values in a table. I set up a query that can calculate the average, but when I add StDev (from the combo box in the QBE grid) and run the query I get #Error as the result.<br><br>I created a simple table with only two fields, ID (Text) and number (Number, Double). <br>Then I made a query with Group By in the Total row of ID column, and StDev in the Total row of the Number column. I still get #Error as the result.<br><br><br>What am I doing wrong?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem using StDev in a query
- Thread starter KenG
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
