How to add analysis function for access?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Does anyone have any suggestions on how to add analysis function for accesss?
I need use analysis function for me to export Access file into Excel file or
such like.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
Access data is easily output to Excel, both through the menu/ribbon and
through VBA code.
 
But how to add analysis function for access?
Thank you very much for any suggestions
Eric
 
Eric,

Access has hundreds of analysis functions. What specific analysis function
are you referring to?

The word "add" implies that it's not already in Access. How do you know
that Access does not have the function that you are seeking?
 
Again, you can output your data into Excel and use the Excel functions
there. You do not need to use Excel functions in Access. Remember, you
should never be storing the results of a calculation in a database anyway,
unless they have historical value and the elements of the calculation are
not being stored.

You can, if necessary use Excel functions. Every Excel function is available
in Access if you set a reference to Excel in any Access code window. Then
you can use code like:

Public Function XL360(DateStart As String, DateEnd As String) As Double
Dim objXL As New Excel.Application
XL360= objXL.WorksheetFunction.Days360(DateStart,DateEnd)
Set objXL = Nothing
End Sub

?XL360("1/1/07", "12/31/07")
360
 
Back
Top