Count number of entries each day

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! ^_^!
 
D

Duane Hookom

I expect you need a simple totals query like:
SELECT Entry_Date, Count(Tader) as NumOf
FROM [a table]
GROUP BY Entry_Date;
 

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

Top