D
DM
How do I put Standard Deviation into a report?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
damr
If you use Excel you can put a formula to calculate your results
Regards
Dil
Regards
Dil
R
Raghu Prakash
Hi DM,
StDev, StDevP Functions Help
Assistance > Access 2003 > Creating and Working with Databases and Objects
Return estimates of the standard deviation for a population or a population
sample represented as a set of values contained in a specified field on a
query.
Syntax
StDev(expr)
StDevP(expr)
The expr placeholder represents a string expression identifying the field
that contains the numeric data you want to evaluate or an expression that
performs a calculation using the data in that field. Operands in expr can
include the name of a table field, a constant, or a function (which can be
either intrinsic or user-defined but not one of the other SQL aggregate
functions).
Remarks
The StDevP function evaluates a population, and the StDev function
evaluates a population sample.
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 cannot be calculated).
You can use the StDev and StDevP functions in a query expression. You can
also use this expression in the SQL property of a QueryDef object or when
creating a Recordset object based on an SQL query.
For Further Information :
http://office.microsoft.com/en-us/assistance/HP010322691033.aspx
Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
StDev, StDevP Functions Help
Assistance > Access 2003 > Creating and Working with Databases and Objects
Database Objects > Queries > Microsoft Jet SQL Reference > Functions
Return estimates of the standard deviation for a population or a population
sample represented as a set of values contained in a specified field on a
query.
Syntax
StDev(expr)
StDevP(expr)
The expr placeholder represents a string expression identifying the field
that contains the numeric data you want to evaluate or an expression that
performs a calculation using the data in that field. Operands in expr can
include the name of a table field, a constant, or a function (which can be
either intrinsic or user-defined but not one of the other SQL aggregate
functions).
Remarks
The StDevP function evaluates a population, and the StDev function
evaluates a population sample.
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 cannot be calculated).
You can use the StDev and StDevP functions in a query expression. You can
also use this expression in the SQL property of a QueryDef object or when
creating a Recordset object based on an SQL query.
For Further Information :
http://office.microsoft.com/en-us/assistance/HP010322691033.aspx
Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.