Problem with Count.

[Jimcb8]

I have a field in a table called Race. I am trying to Count the number of record for each race in this field.
It works fine for the first Race. Example
Race
Tablename
COUNT
"Latino"
Then I run it and all is ok
If I add another race next to the column above now my query has two columns)
Race
Tablename
COUNT
"White"
it give me an error to the effect that it is too complicated or complex a satement
I am new to Access so please help.
Thanks

 

[pbaldy]

Try this query:

SELECT Race, Count(*) As HowMany
FROM TableName
GROUP BY Race

 

[Jimcb8]

Thank you so much for this solution pbaldy. I can't thank you enough.
What does Count(*) do? When I looked it up in my testing it did not make sense.


Jim

 

[pbaldy]

Happy to help. The * simply makes it count every record, which is more efficient than specifying a field.