[AccessD] Pick out the Year

Brett Barabash BBarabash at TappeConstruction.com
Thu Jan 29 12:10:55 CST 2004


How about:
DatePart("yyyy", <datefield>)

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com]
Sent: Thursday, January 29, 2004 11:27 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Pick out the Year


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

--------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have received this email in error please notify the
originator of the message. This footer also confirms that this
email message has been scanned for the presence of computer viruses.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Tappe Construction Co.

Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with 
virus detection software.



More information about the AccessD mailing list