[AccessD] A2K: Date in Query

Hmmm....A lot of people contribute great answers often complete with code.
The best of these could be invited to present them in question and answer
form for use on the website. If this is done as they occur (a best answer of
the week award?)   it would, over time, produce a respectable body of
knowledge. DBA could even raise operating funds by  publishing a book along
the lines of the Access Cookbook (which earlier was published as the Access
95 How To). Just a thought.

Jim Hale

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com]
Sent: Wednesday, June 18, 2003 12:36 AM
To: 'accessd at databaseadvisors.com'
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030618/d365d68e/attachment-0001.html>