Grouping and counting

[joe]

I am using Access 2007.

I have a table of real estate sold by several thousand agents. I want to count
the number of sales made by each agent (I can group by each agent's unique user
ID).

Other than generating a report, how can I accomplish this with a query?

Joe Parsons

 

[Allen Browne]

In query design view, depress the Total button on the toolbar.
Access adds a Total row to the design grid.

In the Total row udner the agent's ID, choose Group By.

In the Total row under the primary key field, choose Count.

 

[Joe Parsons]

In query design view, depress the Total button on the toolbar.
Access adds a Total row to the design grid.

In the Total row udner the agent's ID, choose Group By.

In the Total row under the primary key field, choose Count.

Perfect. Thank you!

Joe Parsons