Count of field hits 2

[toyt78]

I have information:

ID value
1 1
2 1
3 2
4 1
5 3
2 2

I need to get a count of how many times each value occurs:
1 occurs 3 times
2 occurs 2 times
3 occurs 1 time

The sql here gave me a value but not the total number of occurences of each value in the Access 2000 database:

select count(value) as theValue
from Project

 

[DotNetGnat]

select count(value) as theValue
from Project GROUP BY value

-DNG

 

[DotNetGnat]

i think it is

select count(value) as theValue
from Project GROUP BY ID

-DNG

 

[flyover789]

I think it should be

SELECT value, count(value) AS CountOfValue
FROM Project GROUP BY value;

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]

 

[DotNetGnat]

yes..should be Group By value...

-DNG