Count Group By

[Guest]

I have a table of transactions for multiple iterations of the same policy number. The Group By function works to LIST the distinct policy numbers, but how do I COUNT those "grouped" policy numbers to show results below
The "kicker" is I'd like to use the query design view in Access (not paste and copy SQL)..
e.g.
trans 1, policy number ab
trans 2, policy number ab
trans 1, policy number xy
Results = 2 Policy numbers (not 3)

 

[Lynn Trapp]

In Query Design, select View > Totals. Set the Policy Number to Count

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I have a table of transactions for multiple iterations of the same policy

number. The Group By function works to LIST the distinct policy numbers,
but how do I COUNT those "grouped" policy numbers to show results below?

 

[Michel Walsh]

Hi,



Make first a saved query, q1, out of your GROUP BY query, then, make a
second query:

SELECT COUNT(*)
FROM q1



You just count the number of records returned by the first query, which is
what it seems you seek.

Hoping it may help,
Vanderghast, Access MVP

I have a table of transactions for multiple iterations of the same policy

number. The Group By function works to LIST the distinct policy numbers,
but how do I COUNT those "grouped" policy numbers to show results below?