Count in a Query

S

Skigirl

Hello.

I created a query from my employee table. One of my fields is named Title.
Within that field I have more than one type of title.
Example: Titles are KBSI, KBSII, CLRKI, CLRKII etc.
I want the total number of each title. I think I am supposed to use the
count feature but I cannot figure out how.
Please Help!
Thanks!
 
D

Duane Hookom

Or,

Select Title, count(*) as NumOf
From [yourtable]
Group By Title;

--
Duane Hookom
MS Access MVP
--

Matt Williamson said:
Try

Select count(*) from [yourtable]
Where Title = 'KBSI'

etc.

HTH

Matt

Skigirl said:
Hello.

I created a query from my employee table. One of my fields is named
Title.
Within that field I have more than one type of title.
Example: Titles are KBSI, KBSII, CLRKI, CLRKII etc.
I want the total number of each title. I think I am supposed to use the
count feature but I cannot figure out how.
Please Help!
Thanks!
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Employee count with multiple parameters... 1
Working on birthday "book" for my wife and having layout/editing trouble 0
Count of Multiple queries 4
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Unable to count multiple fields in a single query 2
Create a query for specified text in a field 2
Identify letters but not spaces 2
Show select table entries based on yes/no checkbox answers 1

Top