SELECT COUNT(DISTINCT Field) ... Not Working... What am I missing?
Posted on 2004-10-07
Here is the deal, I am trying to Count all of the unqiue groups in a table. I thought it should be as easy as :
SELECT COUNT(DISTINCT tGroup)as 'CNT' From Terms
I have checked a few other posts on here to confirm my syntax... unless I am overlooking a detail, it should be right.
This is the error I receive:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'COUNT(DISTINCT tGroup)'.
/inc/functions/dbConn.asp, line 10