Recent content by Randy U

One more thing.... If all 6 values are the same and they are =< 2 as a whole number or decimal like 0.5 then I get the error. If the values are all 4 as a whole number then I get the error. If the values are all the same except for the above numbers then i get that funky scientific date type...

How about just deleting the modules? If you dont need them get rid of them.

It's specifically this part that is giving the following error: "Invalid Procedure Call or Argument" RStDevP = Sqr((n * dblSumOfSq - dblSum * dblSum) / n / n)

The Data type is Double

Easier than code it the GUI way. I assume that the values in your list box are known or you would just use a text box, so..... Create a table that contains the know values. Bind the list box to the table and column you want to populate. Set the Row Source Type to Table/Query In Row Source create...

I have a module that I have made a custom function in. It calculates the Standard Deviation for row level values. I use 6 variables in the Sub Procedure on the form. If I use 1, 2, 3 or 4 variables it returns a value that looks like a "Scientific" data type "ie: 5E-07" If I use 5 or 6...

The values are in different "columns" of the same row in 1 table. Can someone help me with the proper code?

I am having issues making calculations in a report. I have 2 groups of 6 text boxes that contain numeric values on the form. From each of those groups of six I need to extract an average and a standard deviation (StDevP). How can I do this on the report level without having to go into...

Thanks Rich

I have a table that I can directly input a value such as 0.997854 but when I create a form the value will only display "0" and thats also what gets populated into the table. The values must be exact down to say 5 places after the decimal. Am I using the wrong data type? This is the code I am...