Percentiles in MS Access cont.
Posted on 2007-07-30
This is a continuation of a previous question "Percentile Calculations in MS Access" that was already answered by harfang...
The SQL you given for expanding the criteria did not work for me, so i modified the syntax a bit (in regards to the AND statement)....
SELECT Percentile(0.25,"temp","water","time=" & water.time and "DOY=" & water.DOY) AS P25, water.time, water.DOY
GROUP BY water.time, water.DOY;
However, I still can't get it to run. I tried a few other changes, and still no go.
Do you see anything wrong with the syntax I have here?