|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 5th, 2009, 04:24 AM
posted to microsoft.public.access
|
|||
|
|||
How to add analysis function for access?
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 
|
|
#2
May 5th, 2009, 04:46 AM
posted to microsoft.public.access
|
|||
|
|||
|
How to add analysis function for access?
Access data is easily output to Excel, both through the menu/ribbon and
through VBA code. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Eric" wrote in message ... 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
|
|
#3
May 5th, 2009, 07:21 AM
posted to microsoft.public.access
|
|||
|
|||
|
How to add analysis function for access?
But how to add analysis function for access?
Thank you very much for any suggestions Eric "Arvin Meyer MVP" wrote: Access data is easily output to Excel, both through the menu/ribbon and through VBA code. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Eric" wrote in message ... 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
|
|
#4
May 5th, 2009, 01:28 PM
posted to microsoft.public.access
|
|||
|
|||
|
How to add analysis function for access?
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? "Eric" wrote: But how to add analysis function for access? Thank you very much for any suggestions Eric "Arvin Meyer MVP" wrote: Access data is easily output to Excel, both through the menu/ribbon and through VBA code. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Eric" wrote in message ... 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
|
|
#5
May 5th, 2009, 02:03 PM
posted to microsoft.public.access
|
|||
|
|||
|
How to add analysis function for access?
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 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Eric" wrote in message ... But how to add analysis function for access? Thank you very much for any suggestions Eric "Arvin Meyer MVP" wrote: Access data is easily output to Excel, both through the menu/ribbon and through VBA code. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Eric" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
