[AccessD] Pick out the Year

Hollis,Virginia HollisVJ at pgdp.usec.com
Thu Jan 29 11:27:12 CST 2004


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.

Virginia


More information about the AccessD mailing list