Querry

L

lmossolle

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?
 
M

[MVP] S.Clark

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")
 
Top