Im having trouble with my order by.... heres what i have...
SELECT Count(Table1.assigned) AS Expr1
group by assigned
order by Expr1 DESC;
I actually dont need the value of who has the most occurances, just the amount of the most occurances. Im using access and its prompting me to specify the value of exp1?
Tried this as well form within my vba script:
SELECT count (assigned) as CountOfassigned FROM table1 GROUP BY assigned ORDER BY CountOfassigned DESC //gives me error in sql syntax
SELECT count (assigned) as CountOfassigned FROM table1 ORDER BY CountOfassigned DESC GROUP BY assigned // gives me too many too few paramters error