Getting DISTINCT and COUNT

[AccessSHELL]

I have an Access DB with a table containing 3 columns.
COL 1: Date
COL 2. ArticleTitle
COL 3. CategoryTitle

I am only interested in the CategoryTitle for this query

As an example, I can have several CategoryTitle s with many Duplicates.



I need a query that gives me the DISTINCT CategoryTitles and the count per title.

Is this possible with one query. If not, then that's why I am having difficulty writing it.

If, yes, then can you hep mewrite the query?

Thanks

[June7]

On first read, looks like a simple aggregate query.
SELECT CategoryTitle, Count(*) AS Cnt FROM table GROUP BY CategoryTitle;

If that doesn't produce what you want, then perhaps provide some sample data and desired output. Use the table builder on the Advanced post editor or copy/paste from Access table.

[AccessSHELL]

This is exactly what I need.
Thank you June7