statistics in access

[amal .T]

Hi,

i want to know if it access has statistical functions like (regression,etc...)

tnk u

 

[Martin]

It doesn't but you can borrow Excel's by ticking M/soft Excel Object Library
in Tools, References (in VB Editor) and then using something like:

Sub UseExcel()
Dim myXL As New Excel.Application
myXL.WorksheetFunction.ChiDist()
End Sub

 

[Martin]

Actually, this is a more useful form as it makes a usable function in Access
(i.e. you could use it in a query or form/report):

Function myChi(ref1, ref2)
Dim myXL As New Excel.Application
myChi = myXL.WorksheetFunction.ChiDist(ref1, ref2)
Set myXL = Nothing
End Function

 

[amal .T]

thank u
--
Amal.T

Actually, this is a more useful form as it makes a usable function in Access
(i.e. you could use it in a query or form/report):

Function myChi(ref1, ref2)
Dim myXL As New Excel.Application
myChi = myXL.WorksheetFunction.ChiDist(ref1, ref2)
Set myXL = Nothing
End Function

 

[amal .T]

hi,
i have another question, i use access to create tables ,and vb to programm
the interface so i need to know if there is possible to use the statistics
functions in excel even if i dont use it

thank u

 

[Douglas J Steele]

Take a look at Total Access Statistics, from FMS:
http://www.fmsinc.com/products/statistics/index.html

 

[Martin]

Should be OK if you've got reference to M/soft Excel Object Library