Why Won't Variance & Standard Deviation Work

  • Thread starter Thread starter WSR
  • Start date Start date
W

WSR

Access 2007.

I've created a Query and at the bottom of the data, I'd like to run:

Sum (which works)
Average (which works)
Count (which works)
Maximum (which works)
Minimum (which works)

Standard Deviation (which does not work)
Variance (which does not work)

I do not have any formatting associated with the field in Design View. It's
Currency with Auto decimal places in the source table.

Any ideas?

(B^>)-]=[
 
They return an answer only if there is at least 2 records which will belong
to the group, after the WHERE clause would have been evaluated; else, if
there is only one record in the group, the variance is NULL.

Vanderghast, Access MVP
 
My Query has 76 records in it.

I believe all my records are in the same group as you mentioned.


vanderghast said:
They return an answer only if there is at least 2 records which will
belong to the group, after the WHERE clause would have been evaluated;
else, if there is only one record in the group, the variance is NULL.

Vanderghast, Access MVP


WSR said:
Access 2007.

I've created a Query and at the bottom of the data, I'd like to run:

Sum (which works)
Average (which works)
Count (which works)
Maximum (which works)
Minimum (which works)

Standard Deviation (which does not work)
Variance (which does not work)

I do not have any formatting associated with the field in Design View.
It's Currency with Auto decimal places in the source table.

Any ideas?

(B^>)-]=[
Click to expand...
Click to expand...
 
Try to add a COUNT(*). If you get 1, then you can't have a meaningful
variance (for each group having a count of 1 ).


Vanderghast, Access MVP



WSR said:
My Query has 76 records in it.

I believe all my records are in the same group as you mentioned.


vanderghast said:
They return an answer only if there is at least 2 records which will
belong to the group, after the WHERE clause would have been evaluated;
else, if there is only one record in the group, the variance is NULL.

Vanderghast, Access MVP


WSR said:
Access 2007.

I've created a Query and at the bottom of the data, I'd like to run:

Sum (which works)
Average (which works)
Count (which works)
Maximum (which works)
Minimum (which works)

Standard Deviation (which does not work)
Variance (which does not work)

I do not have any formatting associated with the field in Design View.
It's Currency with Auto decimal places in the source table.

Any ideas?

(B^>)-]=[
Click to expand...
Click to expand...
Click to expand...
 
Back
Top