[AccessD] A2K: Date in Query

Well, maybe someone should make up a list of topics, and we can post about
them, to create a ad-hoc 101 course here.  Pick a topic a week.

Like Query Building, Table Design, Shortcut keys, etc.

Drew

-----Original Message-----
From: Darren DICK [mailto:d.dick at uws.edu.au]
Sent: Wednesday, June 18, 2003 12:20 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A2K: Date in Query


I would love a 101 Course - really
We can do it Via videoconference <vbg>


----- Original Message ----- 
From: "Drew Wutka" <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, June 18, 2003 2:37 PM
Subject: RE: [AccessD] A2K: Date in Query


> Year(Date()).  Without the (), the query thinks it's text.
> 
> Do we need an Access 101 course Darren?  <evilgrin>, just kidding, I've
been
> nabbed about a dozen times in the past week for putting Date in a query,
and
> having it quote it on me...ARG!  I need a vacation!
> 
> Drew
> 
> -----Original Message-----
> From: Darren DICK [mailto:d.dick at uws.edu.au]
> Sent: Tuesday, June 17, 2003 10:31 PM
> To: AccessD List
> Subject: [AccessD] A2K: Date in Query
> 
> 
> Hello all
> When I put msgbox Year(Date) behind a button click I get 2003. No Prob
> When I put that criteria Year(Date) into a query Access changes it to
> Year("Date")
> and of course it fails.
> What is the correct syntax to search on the 'current year' on a field that
> holds that data?
> 
> Many thanks
> 
> Darren
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com