Summing the days with the same date 2

[Dophia]

Hello Everyone: I have a query which includes the date. I want to total the number of records with the same date

Jan 1 2014 xx
Jan 1 2014 xt
Jan 10 2014 xu
Jan 15 2014 st

I want to show
Jan 1 2014 2
Jan 10 2014 1
Jan 15 2014 1

Can anyone suggest how I can do this?

Thank you, Sophia

 

[SkipVought]

Hi,

Select [your date], count(*)
From [your table]
Group by [your date]

 

[Dophia]

Thank you for your help. How would I put that in a query?
Sophia

 

[SkipVought]

Just copy 'n' paste into your query SQL window.

 

[Dophia]

Hi Again: That seems to give me a "1" for every date and not like I wanted. Here is my query. Any further suggestions would be appreciated.


SELECT tblAnimal_ReleaseOther.Pound_Sheet_No, tblAnimal_ReleaseOther.Date_Released, Count(tblAnimal_ReleaseOther.Date_Released) AS Expr1
FROM tblAnimal_ReleaseOther
GROUP BY tblAnimal_ReleaseOther.Pound_Sheet_No, tblAnimal_ReleaseOther.Date_Released;


Sophia

 

[dhookom]

You need to get rid of the Pound_Sheet_no from the query.

SELECT tblAnimal_ReleaseOther.Date_Released, Count(tblAnimal_ReleaseOther.Date_Released) AS DateCount
 FROM tblAnimal_ReleaseOther
 GROUP BY tblAnimal_ReleaseOther.Date_Released;

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

SELECT 
  Date_Released
, Count(Date_Released) AS Expr1

FROM tblAnimal_ReleaseOther

GROUP BY Date_Released;

 

[Dophia]

Thank you both very much! It works
Sophia