Can a query get lots of totals? 1

[kupe]

In the ‘Group’ row in the table are 16 different groups. In the row ‘Division’, each record belongs to one of 10 different divisions.

Can I count how many Group1s are in Division 1-10, and Group2s in 1-10 etc, and then through each of the groups, please?

 

[azzazzello]

How bout this...

SELECT Group,Division,count(Group) FROM table GROUP BY Division,Group;

 

[kupe]

That looks really interesting, azzazzello. And repeat it 160 times? And yet ... I'll have to think on it and try it. Many thanks.

 

[kupe]

I think I must be seeing things! Can this really do the basic job? I've just tried it in a test db. Looks amazing. I'll try it closer to the real thing and report back. Cheers

 

[kupe]

Azzazzello for King! It works really well adapted into a cross tab query. I'm new to sql, admittedly, but almost every day I am amazed by sql's power. Very grateful for your help.