User Profile

Collapse

Profile Sidebar

Collapse
ctate
ctate
Last Activity: Mar 17 '08, 09:51 AM
Joined: Jan 2 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ctate
    replied to How to Calculate skewness and Kurtosis in Access2003 using VB
    in Access
    I have now added the excel libary to vb

    what i am struggling with is how do a write the script to call the excel function .

    I see from the ms office site that it needs to start but how do i finish it ?

    Is this correct?

    Code:
    Sub xlKurt()
   Dim objExcel As Excel.Application
   Set objExcel = CreateObject("Excel.Application")
   MsgBox objExcel.Application.kurt(do
    ...
    See more | Go to post

      Leave a comment:

    • ctate
      started a topic Carriage Return in MS Access
      in Access

      Carriage Return in MS Access

      I have a query in sql as below - where the scan result feild is a memo feild with multiplue lines of data seperated by carriage returns.

      The is no common delimiter at the end of the field (apart from the word 'approx', i was wondering if there is a way of seperating out these lines into indivdiual lines of data.

      Is this possible without a delimiter, if not would it be possible with a delimiter added to the lines?...
      See more | Go to post
      Last edited by Scott Price; Mar 3 '08, 04:13 PM. Reason: code tags
      • ctate
        replied to How to Calculate skewness and Kurtosis in Access2003 using VB
        in Access
        I wish to store them in a table for a data set at a point in time. I notice someone has said i can integrate the excel functions in to access how do i go about doing this ?

        I currently have a query that i calculate mean median percentiles min max values and wish to add the Kurtosis and skewness too.

        If it helps i have pasted an sql version of my query

        [CODE=sql]SELECT temp_AqR3.Deter minand_Name, temp_AqR3.Units ,...
        See more | Go to post
        Last edited by Scott Price; Mar 3 '08, 04:10 PM. Reason: code tags

          Leave a comment:

        • ctate
          started a topic How to Calculate skewness and Kurtosis in Access2003 using VB
          in Access

          How to Calculate skewness and Kurtosis in Access2003 using VB

          Dear All,

          I want to write an user defined aggregate function to calculate skewness and Kurtosis of data in a column of a table. Could you please help me to do that.

          I know how to add the code to make it work in a query but struugle to write my own code

          Any help would be greatly appreciated



          Regards

          Chris
          See more | Go to post
          No activity results to display
          Show More
          Working...