select count query

  • Thread starter Thread starter Striker3070
  • Start date Start date
S

Striker3070

I have a ACCESS07 table that has a field called Unit, and another field
called Members. Each unit can have up to 48 members, and there are many
units in the table.

I need to figure out how to do a select count to find out how many members
each unit has. Nothing I try works. So how would I do a select count for
each unit and return the number of members in it.
 
You need to use GROUP BY.

Example:

SELECT Unit, Count(Members)
FROM aTable
GROUP BY Unit;
 
Back
Top