Count Query

[Greg]

I have a table of records that all have a student name with them, there are
many duplicates of student name. I want to design a query to count the number
of times each person is on this list.

How do I do this?

Greg
The Oft Access Confused

 

[Dennis Schmidt]

Hi Greg,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

Use the Totals button in your query. For a very basic example, add the
last name twice. With the Totals button on, it sets both Total lines to
GroupBy. Change the last one to Count.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support