[AccessD] Parse Year

Hollis, Virginia hollisvj at pgdp.usec.com
Wed May 23 08:12:54 CDT 2007

Previous message: [AccessD] Select statement with variable as field name
Next message: [AccessD] Parse Year
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

How do I parse out the year in a query for dates in this format?

 

5/2/2005 10:23:44 AM

 

I need to create a query from Access data for a graph in Excel. The
graph needs to show the total number of projects completed each year.
The dates are formatted as shown above so I need to get the year to
group them by the year.

 

Virginia

Previous message: [AccessD] Select statement with variable as field name
Next message: [AccessD] Parse Year
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the AccessD mailing list