Ms access issue

[Ramesh pokharia]

Hi !

I need help to reslove this issue.

I'm doing a project and using MS Access to do analysis on
approximately 50,000 cases.I plan to segment this data via
various MS Access query methods and then use an Append
Query to place time values into a pre-defined, one-column
table.

My question is around how do I take the values from this
predefined table (which may have variable length) and
identify which values, when ranked in ascending order, are
at the 5th & 95th percentile?

I have been able to do this via a cut-and-paste into Excel
utilizing the "PERCENTILE(Array,0.05)" function.
This function appears in the Help section for MS Access
but is not recognized when used in a Query.

It would be great if you could let me know which function
to use and also include a sample DB with one table & one
query.

Thank you very much.
Ramesh Pokharia

 

[Jeff Boyce]

Ramesh

While you may be able to see the function in HELP, Access may not have a
reference to it.

Open a module, click References, and see if Excel is selected. If not,
select it. By referencing Excel's object model, you should be able to
employ Excel's functions.

Good luck

Jeff Boyce
<Access MVP>