Count number of entries each day

  • Thread starter Thread starter ali
  • Start date Start date
A

ali

I have a table:

Tader Entry_date
Allen 1/Jan/2008
Steve 1/Jan/2008
Johnson 1/Jan/2008
James 2/Jan/2008
Timbery 2/Jan/2008
Deanel 3/Jan/2008
Steve 4/Jan/2008
Stevenson 5/Jan/2008
Joey 6/Jan/2008
Stelthy 7/Jan/2008
David 10/Jan/2008
--------------------------------------------------------------------------------------------

I want to count how many trades occur in each day
---------------------------------------------------------------------------------------------

I'm expecting the result to be something like this:

1/Jan/2008 - 3
2/jan/2008 - 2
3/jan/2008 - 1
4/jan/2008
-
-
-
-


Thanks a lot experts! ^_^!
 
I expect you need a simple totals query like:
SELECT Entry_Date, Count(Tader) as NumOf
FROM [a table]
GROUP BY Entry_Date;
 
Back
Top