Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to sum up a grouped count?

Status
Not open for further replies.

yuenie

Programmer
Jul 20, 2000
15
0
0
HK
Thanks. I got no idea on how to make a sum on a count result inside a GROUP.<br><br>&gt;yuenie.
 
Do a count on same field as you did originally, but make it for the whole report (or another group if you want). <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
 
Thanks MalcolmW, but sorry I don't quite understand what you meant. What I have done is:<br><br>1. I linked up 2 tables with their IDs, {A.ID} and {B.ID}<br>2. I make a group for {A.ID}<br>3. Do the count on {B.ID} inside each {A.ID} Group<br><br>I apologize for the oversimplified statement in the last post.<br><br>&gt;Yuenie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top