I have a database that contains articles written by different departments. I am
trying to find the distinct number of departments and count them so I know how
many rows I have to populate another query using maxrows. I have tried:
<CFQUERY NAME="numb" DATASOURCE="design">
SELECT COUNT(DISTINCT department_id ) AS deptCount
I understand that this code will not work with Microsoft Access. I can get
the Count or the Distinct to work seperately, but not together, which is what I
I am pulling out, what's left of, my hair. Does anybody have any suggestions?