[AccessD] Query: Filter date column on year SOLVED!

Thnx debbie!
Works like a charm.

Regards,

SD

--- "Elam, Debbie" <DElam at jenkens.com> wrote:

> Where DatePart('yyyy',[DateField]) = 2005
> 
> Debbie
> 
> -----Original Message-----
> From: Sad Der [mailto:accessd666 at yahoo.com] 
> Sent: Friday, June 17, 2005 7:01 AM
> To: Acces User Group
> Subject: [AccessD] Query: Filter date column on year
> 
> 
> Hi group,
> 
> I've got a query with a date field in it. Values are
> formatted like:
> mm-dd-yyyy
> 
> I want to retrieve all values equal to a certain
> year.
> With what statement can I do this?
> 
> TIA
> 
> SD
> 
> 
> 		
> ____________________________________________________
> 
> Yahoo! Sports 
> Rekindle the Rivalries. Sign up for Fantasy Football
> 
> http://football.fantasysports.yahoo.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> - JENKENS & GILCHRIST E-MAIL NOTICE - This
> transmission may be: (1) subject
> to the Attorney-Client Privilege, (2) an attorney
> work product, or (3)
> strictly confidential. If you are not the intended
> recipient of this
> message, you may not disclose, print, copy or
> disseminate this information.
> If you have received this in error, please reply and
> notify the sender
> (only) and delete the message. Unauthorized
> interception of this e-mail is a
> violation of federal criminal law. 
> This communication does not reflect an intention by
> the sender or the
> sender's client or principal to conduct a
> transaction or make any agreement
> by electronic means.  Nothing contained in this
> message or in any attachment
> shall satisfy the requirements for a writing, and
> nothing contained herein
> shall constitute a contract or electronic signature
> under the Electronic
> Signatures in Global and National Commerce Act, any
> version of the Uniform
> Electronic Transactions Act or any other statute
> governing electronic
> transactions.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



		
____________________________________________________ 
Yahoo! Sports 
Rekindle the Rivalries. Sign up for Fantasy Football 
http://football.fantasysports.yahoo.com