Querry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Table that has a date format and it is using a short date. I want to
only see the month and year. I also want them grouped. Can someone show me
the light?
 
I'm guessing that you have a field in said table that is a date/time, and
that that field is currently displaying the value as a short date. Assuming
that field is called [DateField], you could do something like the following:

SELECT Format([DateField], "yyyymm"), Sum([AnotherField]),
Count([Something])
FROM Tablename
GROUP BY Format([DateField], "yyyymm")
 
Back
Top