Count of unique values based on another column's unique values

[Ace71425]

So my brain is fried for the day...here's what i'm trying to do...I have a table that has columns that are...

Rep, Action, Date
John Call 10/20/2015
Billy Call 10/21/2015
Jane Call 10/20/2015
Jane Email 10/21/2015
Jane Call 10/20/2015
Billy Email 10/19/2015

I would like this sorted with a query so that it shows the rep's name, the action taken, the date, and the count of action taken by date essentially so it would look something like below.

Rep, Date, Action, Count
John 10/20/2015 Call 1
Billy 10/19/2015 Email 1
Billy 10/21/2015 Call 1
Jane 10/20/2015 Call 2
Jane 10/21/2015 Email 1

So now the query would show the count of what everybody did on each day, IE Jane made 2 calls on 10/20/2015. Thus the title of the question count of unique values (Actions) based on the unique values of (Date). Maybe that's not the best way to phrase it but you get the picture.

Let me know if this isn't clear enough. As always I greatly appreciate it!

 

[Joe4]

Simply make this an Aggregate (Totals) Query.
- Add those three fields two your query, and then add any one of this field again (so you have a fourth field).
- Click on the "Totals" icon (looks like a Sigma).
- Under the 4th field, on the Totals row, change the "Group By" value to "Count".
- View your results.

 

[mathematician]

Create a query based on the table containing your data, say "yourTable". After adding yourTable in design view click SQL view and paste the following SQL code.

SELECT yourTable.Rep, yourTable.Action, yourTable.Date, Count(yourTable.Action) AS CountOfAction
FROM yourTable
GROUP BY yourTable.Rep, yourTable.Action, yourTable.Date
ORDER BY yourTable.Rep;

Then go back to query design view to check and learn how it should have been designed in design view.