GROUP BY scenario.

I am trying to figure out how I can group records by year, i.d.,

2007 - 25,000
2008 - 15,000

And the date filed has full date - mm/dd/yyyy

Is there a way to accomplish this?

Thanks for any help

~Chip

If you just want to fetch the total, this should do it:

select count(*)
from table
group by date(date_field)

Not sure if access supports DATEPART() but try;

GROUP BY DATEPART("yyyy", date_column)

Thanks for the quick reply Chris. I'll try this. I'll let you know if it works with access.

Hum, my bad... I did not checked for which db.
My solution is only valid for mysql/postgresql.
Sorry.

Didn't work with access. It grouped by the full date.

I think I might just add another field that is specifically the Year. Then use this to group by. IN the long run it will probably be quicker..!

Any thoughts?

Thanks,

Chip

Group By Format(dateValue, "yyyy")