[AccessD] Pick out the Year

Hi Virginia

How about

  .. Group By Year(datefield), Month(datefield);

/gustav


> I have a date field showing the standard date format of mm/dd/yyyy. I need
> to group and count records by the month & year. For example, I need a count
> of all records entered in January 04.

> How do I parse out the month from the date? I tried the left function, but
> get a data type mismatch.