I have an access query that computes an average and then finds the max value of each of these averages using stored procedures.
how do I do this as the version of sql I am using now says that MAX(AVG(hits)) is invalid.
SELECT member,memtype,avg(hits)
FROM MEMBERS
GROUP BY member,memtype
How...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.