SELECT COUNT(DISTINCT userColors) as colorTotal FROM tblUser
it make sense!!
here the error
Code:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'COUNT (DISTINCT userColors)'.
/stats.asp, line 7
