Grouping and counting

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
 
A

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.
 
J

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

Perfect. Thank you!

Joe Parsons
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total appointments per agent 2
Average cases handled per agent in Sorting and Grouping report 0
Custom toolbar button for search and replace 1
Sum a count total 4
Set up and printing a 4-up mail merged postcard 0
Grouping and counting question 1
Count by short date and group by agent name 10
Expression Multiplying Hours by a Number 1

Top