Help - Brain Freeze on Query Count

[GACat]

I did a search and could not find anything that I think is like what I am trying to do (if possible).

I am trying to have a query that will count all items in the "Name" field that are the same.

The goal is to get a count of everyone with the same name - for each name.

Is it possible?
Thanks

 

[FoFa]

you need something like this:
SELECT COUNT([This Field]) as HowMany, [Some Grouping Field]
FROM MyTable
WHERE some criteria
GROUP BY [Some Grouping Field]

Or use the query designer and hit that totals (greek backwards E thingy) and do it visually.

Basically

 

[GACat]

Thanks - I think I am getting it.