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