[AccessD] A2K: Date in Query

SOunds like a great idea.
Volunteering?? <vbg>

DD

----- Original Message ----- 
From: "Drew Wutka" <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, June 18, 2003 3:35 PM
Subject: RE: [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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com