Grouping and counting

  • Thread starter Thread starter joe
  • Start date Start date
J

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
 
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.
 
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.
Click to expand...

Perfect. Thank you!

Joe Parsons
 
Back
Top