In Access 2000, I have a database with a table in it called STUDENTS. In STUDENTS, there is a column called CLASS. In the CLASS column, there are cells containing either 'A', 'B' or 'C'.
I need to program an SQL query to return the number 3 (There are three different data values in the column CLASS)
This is the code I entered:
SELECT Count(DISTINCT Class)
FROM Students;
I got the following error message:
Syntax error. Missing operator in query.
I've tried a few alternatives, but nothing seems to work! Have microsoft changed SQL between Access 2000 and Acess '98? And if so, how can I get this thing to work?
Here's an example of the table...
CLASS
A
A
B
B
C
It should result in a number 3. There being 3 different classes, A, B and C.
Thanx guys!