Search results

Thank you MajP. Your code works. But do you know how to add a condition that tells the access to first pick out the depths which are between number a and number b and then run the code?

I'm so sorry that I failed to upload the pictures for my original dataset and the final format that I want to achieve. I hope this time it works.

Hi there, I'm trying to find the 5th, 10th, ...,95th percentiles using the ACCESS. The dataset(tblGwMeasurement) contains five columns, which are ID, MP_ID, Depth, Temperature and ElectricalConductivity respectively. I have to find the 5th, 10th, ...,95th percentiles and their corresponding...