Learning Access...need help.

[Banner]

I have a table of employees, town, state, first and last names, etc.




How would I write a query that displays the count of employees by state, i.e. how many are in Florida, how many in Georgia, how many in Alabama, etc.?

[dcrake]

Create a new query that groups by state and counts employee.

David