Prev: Query Question...
Next: averaging specific data
From: WSR on 7 Apr 2010 10:26
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^>)-]=[


From: vanderghast on 7 Apr 2010 10:57
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" <wsr203(a)hughes.net> wrote in message
news:ejF%23L5l1KHA.224(a)TK2MSFTNGP06.phx.gbl...
> 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^>)-]=[
>

From: WSR on 7 Apr 2010 14:40
My Query has 76 records in it.

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


"vanderghast" <vanderghast(a)com> wrote in message
news:OiI53Km1KHA.6104(a)TK2MSFTNGP06.phx.gbl...
> 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" <wsr203(a)hughes.net> wrote in message
> news:ejF%23L5l1KHA.224(a)TK2MSFTNGP06.phx.gbl...
>> 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^>)-]=[
>>
>


From: vanderghast on 7 Apr 2010 15:11
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" <wsr203(a)hughes.net> wrote in message
news:OKQzHHo1KHA.224(a)TK2MSFTNGP06.phx.gbl...
> My Query has 76 records in it.
>
> I believe all my records are in the same group as you mentioned.
>
>
> "vanderghast" <vanderghast(a)com> wrote in message
> news:OiI53Km1KHA.6104(a)TK2MSFTNGP06.phx.gbl...
>> 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" <wsr203(a)hughes.net> wrote in message
>> news:ejF%23L5l1KHA.224(a)TK2MSFTNGP06.phx.gbl...
>>> 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^>)-]=[
>>>
>>
>
>

 | 
Pages: 1
Prev: Query Question...
Next: averaging specific data