Need help: Count on unique entries:

[Clut]

Hi,

I have a table containing some data, simplified here for ease of explaination:

Name : Sex
Alan : Male
Diane : Female
Bob : Male
Kate : Female
Alan : Male

I want to pull out a list of unique names, how often each name appears, followed by whatever other data I have in the table, so I want the results to look like the following:

Alan : 2 : Male
Diane : 1 : Female
Bob : 1 : Male
Kate : 1 : Female

Can anyone help with the SQL to do this?

Thanks

 

[vbaInet]

All you need is a Totals Query. After performing a quick search on Google, here's what I found:

http://office.microsoft.com/en-us/access-help/count-data-by-using-a-query-HA010096311.aspx

 

[Clut]

I experimented with the totals columns.. but when I used the COUNT function, it just returned 5 (the total number of rows in the first example table above).

How do I get it to perform a count within each of the unique entiries in the column instead of just counting the entire column?

 

[Kryst51]

Try adding your name field again as a group by