Trying to calculate percentiles in Access 2000

[Hagal]

My company is on Office 2000 (with no plan to upgrade to newer versions.)
Does anyone have a process to calculate Percentiles in Access 2000? The two
options we've thought of were 1) somehow linking to an Excel spreadsheet,
calculating there and returning values to Access and 2) building a table or
array with the values, sorting them, selecting the relevant value and
returing it.

If you have the language already built, I would be very appreciative of a
copy...

Thanks in advance!

 

[M.L. Sco Scofield]

Don't suppose you tried a Google search, did you? In less than a minute, I
found several hindered possibilities including:

A product from FMS -
http://www.fmsinc.com/products/statistics/index.html#Percentiles and Frequency Distributions

A VBA function -
http://ourworld.compuserve.com/homepages/attac-cg/AQryTip.htm#PCTILE

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com