Counting multiple items in a query

[slaterino]

Hi,


I'm just getting to grips with queries at the moment and was hoping that someone could tell me how to do a query as such.

Imagine there is a table with two fields 'Name' and 'Status.' There are three possible answers to Status; Yes, No and Don't Know.

How would I create a query that would have all the names then listed next to them would be a count for how many said Yes, how many said No, and how many said Don't Know.

This seems like it shouldn't be too hard to do but after playing around for many hours I still haven't worked it out.

Any help would be massively appreciated!

[NoellaG]

Hi,

try a groupsquery: group by answer and count the number of records in each group.
Tip: any beginners handbook or learning website can help you with those topics.

grNG

[weekend00]

While Noellag gave you the way to get the answer(good way to learn), I give you the answer for reference:
select Name,Status,count(*) from aTable group by Name,Status