You could try something like this:
SELECT year, count(studentID) FROM students GROUP BY year
...where studentID is the primary key column/field in your students table.
Josh Hoover
KnowledgeStorm, Inc.
Searching for a new IT solution for your company? Need to improve your
product marketing?
Visit KnowledgeStorm at www.knowledgestorm.com to learn how we can simplify
the process for you.
KnowledgeStorm - Your IT Search Starts Here
> I have a user database where a year has to be put in.
>
> Now, I want to compile a list of each different year and how
> many users are in that year.
>
> Is there a way to do this beyond coding for each year:
>
> SELECT * FROM students WHERE year = '1983' ?
>
> - Kath
>