troubleshooting Question

Percentiles in MS Access cont.

Avatar of dougf1r
dougf1r asked on
5 Comments1 Solution1067 ViewsLast Modified:
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
FROM water
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?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros