Percentile Calculation in Access

[shelby55]

Hello

I am using Access 2003. I have a database that is at patient visit level - 1 line of data per visit.

What I want to do is figure out the patient length of stay at the 90th percentile at the daily, weekly and monthly level.

How do I do this in Access - thanks.

 

[Remou]

Access SQL forum is: forum701

In SQL you can select top n%.

http://lessthandot.com

 

[SkipVought]

Is this MS Access data that you want to use in any of your Excel workbooks?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

The solution is here:
thread701-1613438

 

[SkipVought]

I thought you already got a satisfactory solution as suggested by PHV in another forum.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Remou]

@Skip, this is the post that redirected the OP to Access and a solution by PHV, which PHV has just updated to close this redirect.

http://lessthandot.com