Help Grouping Dates

[tsyle]

I have a database with queries from:

4/10/2005 Data
4/22/2005 Data
4/23/2005 Data2
5/1/2005 Data
5/5/2005 Data2
5/10/2005 Data2

I want to be able to group everything by month so using the data i gave, i want it to be

April 2005 Data 2
April 2005 Data2 1

May 2005 Data 1
May 2005 Data2 2

Help

 

[jrbarnett]

Something like

SELECT Format(Datefield, "Mmmm yyyy") As Date, Max (Otherfield) As Otherfield
FROM tablename
GROUP BY Format(Datefield, "Mmmm yyyy")

should do it. You will need to change the name of the table and field.

John

 

[r937]

slight correction, john

select format(Datefield,"Mmmm yyyy") as DateFld
     , Otherfield
     , [b]count(*)[/b] as rows
  from daTable
group 
    by format(Datefield,"Mmmm yyyy")
     , Otherfield

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[jrbarnett]

Thanks Rudy, I should have spotted that.


John