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


-- 
Allen Phailat Wongakanit

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


"ali" wrote:

> 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! ^_^!
> 
> 
> -- 
> Allen Phailat Wongakanit