statistics in access

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
thank u
--
Amal.T


Martin said:
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
Click to expand...
 
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
 
Back
Top