Re: Standard Deviation

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Roger Carlson (NO-Rog3erc-SPAM_at_hotmail.com)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 13:37:56 -0400

I really don't know. I would look at the query "SLA S-04 Query 3" to see if
something there is causing the problem. Perhaps there is something in the
query the DStdDev function does not like it.

But now you've got me confused. Are you using StDev in an aggregate query
or DStDev on a report? 

-- 
--Roger Carlson
  Access Database Samples: www.rogersaccesslibrary.com
  Want answers to your Access questions in your Email?
  Free subscription:
  http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
<anonymous@discussions.microsoft.com> wrote in message
news:0db401c4abc9$46a34d60$a401280a@phx.gbl...
> Hi Roger:
>
> You are right. The syntax in my previous message is
> correct.  Actually I tried to goup the data before the
> standard deviation is calculated. But when I use StDev or
> StDevP, I got an error message:
>
> "The expression you entered has function containing the
> wrong number of arguments".
>
> Is there any problem with my Access installation or the
> syntax StDev or StDevP does not work?  Your response or
> any suggestion will be very appreciated.
>
> Charles
>
>
>
> >-----Original Message-----
> >As far as I can tell, it has nothing to do with your
> syntax.  It works
> >perfectly for me.  Something else is going on.  Look
> farther afield.
> >-- 
> >--Roger Carlson
> >  Access Database Samples: www.rogersaccesslibrary.com
> >  Want answers to your Access questions in your Email?
> >  Free subscription:
> >  http://peach.ease.lsoft.com/scripts/wa.exe?
> SUBED1=ACCESS-L
> >
> >"Charles Deng" <anonymous@discussions.microsoft.com>
> wrote in message
> >news:016c01c4abc3$fa8d8e90$a301280a@phx.gbl...
> >> Hi All:
> >>
> >> I tried to post standard deviation on my report but the
> >> following syntax does not work (Report shows #error.).
> >> Could anyone do my a favour to check what is wrong with
> my
> >> syntax:
> >>
> >> =DStDev("[q1]", "SLA S-04 Query 3", "[q1]>0")
> >>
> >> Where q1 is variable name in SLA S-04 Query 3 which is
> the
> >> query my report is based.  All records in q1 are
> numberic
> >> and I successfully reported average of q1.  By the way
> my
> >> report is sorted by Department which is not shown in the
> >> syntax.
> >>
> >> Any suggestion and advice will be highly appreciated.
> >> Thanks.
> >>
> >> Chalres
> >>
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: Print report based on value of 2 combo boxes
    ... What I need is the syntax for the rest of the DoCmd.Openreport..... ... The report "AllComputers" will be used for many different queries, ... the computers in the table" to a "particular computer" ... > boxes on the form to filter the query behind your report. ...
    (microsoft.public.access.reports)
  • Follow-up : Parameters using Between Date 1 & Date 2 - Need to use Like too!
    ... "Kahuna" wrote in message ... > I have a parameter query feeding a report. ... > the code once before but cant seem to get the syntax right now. ...
    (microsoft.public.access.queries)
  • Re: On Time Delivery Query
    ... Is there any way to summarize the total of Early, On Time and Late on the query or report? ... Please check my syntax for "finger checks", ...
    (microsoft.public.access.reports)
  • Re: Print report based on value of 2 combo boxes
    ... What it does not do is close the input form after the report appears. ... boxes that gets its options from a special table I use to keep track of all ... the formula (Syntax) that you gave me seems ... boxes on the form to filter the query behind your report. ...
    (microsoft.public.access.reports)
  • Re: Multiple IIfs
    ... "Roger Carlson" wrote: ... > Access Database Samples: www.rogersaccesslibrary.com ... >> report on the results of the query). ...
    (microsoft.public.access.reports)