Problem Using Standard Deviation in Query or Form 1

[Swiftraven]

Hi,
I have a group of numbers within the same record that I need to find the standard deviation of and can not figure out how to do it in either the query or within a form using VB.
The table is set up like
PartNumber IDNumber Description Week1 Week2 Week3... to Week6.
Where the weeks are the demand for the item for each of the past 6 weeks.

I need to find the standard deviation over the 6 weeks.

I have tried to figure out how to do it in the query I use to get the specific Part Number and I have also tried to get it on the form using DStDev and can not figure out how.

Any help is greatly appreciated.

Jason

 

[WildHare]

The DStDev function (I didnt even know there was one..) is a DOMAIN function, and wants to go, if you will, DOWN your database collecting info on ONE field from ALL your records. And you want to go ACROSS your record(s), collecting information from ALL your FIELDS...

See the difference?

This is fallout from not creating a separate MANY side table that will hold your WEEKLY data for each PART number. In that situation, the DStdev Function would work perfectly.

You may have to code an expression on a query that performs the mathematics of a standard deviation on your six fields.

Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[Swiftraven]

Crud..Figured I would have to code it instead of using the functions, just wanted to make sure.

Thanks for your help WildHare!

Jason

 

[WildHare]

It shouldn't be much of a trick to create a function that returns the standard deviation from a set of number passed to it. Then just keep it in a tools module and call it whenever you need a StdDev...

78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm