?
Solved

Select Count of distinct items

Posted on 2008-10-29
1
Medium Priority
?
172 Views
Last Modified: 2012-05-05
I need a SQL statement.

I have a MS Access Table with a "Status" field (column).

There could be any number of distinct values in the Status field

Example

Trader
Keeper
Loaner
etc.

How can I get the totals of each of these from the status field of the table?

Example:

Trader 20
Keeper 9
Loaner 31
etc

thanks

0
Comment
Question by:geocoins-software
1 Comment
 
LVL 9

Accepted Solution

by:
jamesgu earned 1000 total points
ID: 22833690
select status, count(*)
from <table>
group by status
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question