Help with query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Subs - 20 Apr 2006 20:31 GMT

I have a query

Data in column A Data in column B

John xcd
Fred bys
Jim bys
Jim bys

When I do a group by I get

John xcd
Fred bys
Jim bys

If i want to filter on Jim and count the number in Column B
How do I get a query to give me one line that gives me

Jim 2

Thanks for any help

Subs

Reply to this Message

Duncan Bachen - 20 Apr 2006 21:41 GMT

> I have a query
>
[quoted text clipped - 19 lines]
>
> Subs

Turn your select query into a totals query, With Jim as the criteria,
and a count on column B

SELECT ColumnA, Count(ColumnB) AS CountOfColumnB
FROM tblYourTable
GROUP BY ColumnA
HAVING (ColumnA="Jim");

Signature

-D
Duncan Bachen
Director of I.T., Ole Hansen and Sons, Inc.

Reply to this Message