Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Standard Deviation When Only One Record
0 views
Skip to first unread message
Cheryl Lamonds
Oct 13, 2006, 4:33:02 PM10/13/06
to
Access 97. Summary query. Field value is 0 or 1 and have StDev in the total
line. Within a group, if there is only one record I am not getting a value
for standard deviation. Works fine as long as there is more than one record
within the group. I could probably manipulate a value into that field but
I'm not sure I could do it within the same query. Is this how it is
supposed to be?
--
Thanks for any assistance.
line. Within a group, if there is only one record I am not getting a value
for standard deviation. Works fine as long as there is more than one record
within the group. I could probably manipulate a value into that field but
I'm not sure I could do it within the same query. Is this how it is
supposed to be?
--
Thanks for any assistance.
Cheryl
Douglas J. Steele
Oct 13, 2006, 4:40:25 PM10/13/06
to
From the Help file:
"If the underlying query contains fewer than two records (or no records, for
the StDevP function), these functions return a Null value (which indicates
that a standard deviation can't be calculated)."
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Cheryl Lamonds" <Cheryl...@discussions.microsoft.com> wrote in message
news:B9A66994-7D30-480C...@microsoft.com...
0 new messages