Thanks Jeff for your reply. I am sure it is pointing me in the right direction. However, I am having difficulty with defining the function properly I beleve . It must be an array function to Calculate percentiles using the Excel PERCENTILE function. Then I have to access it in an EXCEL query...
Is there a way to incorporate into Access query results through Visual Basic code or (some other method) the Excel basic statistical functions that MS Access lacks (e.g, percentiles)? I have looked at a 3rd-party add-ins but it didn't seem to be convenient to use for my purposes, yield ing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.