Beyond Frustrated - Considering job change

[bill]

I am trying to generate a Standard Error in a report text
box based on a query field. Can anyone let me know if
generating a Standard Error is possible in Access.
Without this statistic my report is useless, and I might
as well scrap the project and put my application in at
the car wash.

Thanks
Bill

 

[Peter Hoyle]

Standard Error looks a touch imposing!

Not sure how you could work this into a report but you can get at the STEYX
function from Access by adding a reference to Excel.

With this reference in place you can then create a function in Access.
Below is an idea how to get this far.


Function StdError(KnownYs As Variant, KnownXs As Variant)
StdError = Excel.WorksheetFunction.StEyx(KnownYs, KnownXs)
End Function

Sub TestStdError()
Dim varKnownYs As Variant
Dim varKnownXs As Variant
varKnownYs = Array(2, 3, 9, 1, 8, 7, 5)
varKnownXs = Array(6, 5, 11, 7, 5, 4, 4)
Debug.Print StdError(varKnownYs, varKnownXs)
End Sub



Getting this to work in the report is still a few more steps away.

Cheers,
Peter

 

[bill]

I guess its off to the car wash after all :-(