[AccessD] Pick out the Year

Gary Kjos garykjos at hotmail.com
Thu Jan 29 13:25:43 CST 2004


Hi Virginia,

When I want to do this I usually will create a field in a query with the 
formatted date in year/month format.

Something like;

OrderYearMonth: Format(OrderDate,"yyyy/mm")

Gary Kjos
garykjos at hotmail.com





>From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem solving'" 
><accessd at databaseadvisors.com>
>Subject: [AccessD] Pick out the Year
>Date: Thu, 29 Jan 2004 11:27:12 -0600
>
>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
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Let the new MSN Premium Internet Software make the most of your high-speed 
experience. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1



More information about the AccessD mailing list