count rows

[Guest]

When I right click on the background of the Diagram pane, in order to choose
'Group By' from the shortcut menu, no shortcut menu appears!

What I need to do is simple:

Given these data:
Pot I.D.
22
22
21
118
118

I would like an out put that counts the pots and outputs the number of pots
with each Pot I.D. :
Pot I.D. # of pots
22 2
21 1
118 2

Thanks!

 

[Guest]

JAS,

Not sure exactly to what you're referring re: the Diagram pane, but the
query you need, assuming the data comes from table "POT", would be:

SELECT pot.[Pot ID], Count(pot.[Pot ID]) AS [# of pots]
FROM pot
GROUP BY pot.[Pot ID];

HTH,
Paul

 

[John Spencer (MVP)]

I don't think you do that from the right click menu.

Try Selecting View:Totals from the menu.