<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] A2K: Date in Query</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>Jim Hale</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Drew Wutka [<A HREF="mailto:DWUTKA@marlow.com">mailto:DWUTKA@marlow.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, June 18, 2003 12:36 AM</FONT>
<BR><FONT SIZE=2>To: 'accessd@databaseadvisors.com'</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] A2K: Date in Query</FONT>
</P>
<BR>
<P><FONT SIZE=2>Well, maybe someone should make up a list of topics, and we can post about</FONT>
<BR><FONT SIZE=2>them, to create a ad-hoc 101 course here. Pick a topic a week.</FONT>
</P>
<P><FONT SIZE=2>Like Query Building, Table Design, Shortcut keys, etc.</FONT>
</P>
<P><FONT SIZE=2>Drew</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Darren DICK [<A HREF="mailto:d.dick@uws.edu.au">mailto:d.dick@uws.edu.au</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, June 18, 2003 12:20 AM</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: Re: [AccessD] A2K: Date in Query</FONT>
</P>
<BR>
<P><FONT SIZE=2>I would love a 101 Course - really</FONT>
<BR><FONT SIZE=2>We can do it Via videoconference <vbg></FONT>
</P>
<BR>
<P><FONT SIZE=2>----- Original Message ----- </FONT>
<BR><FONT SIZE=2>From: "Drew Wutka" <DWUTKA@marlow.com></FONT>
<BR><FONT SIZE=2>To: <accessd@databaseadvisors.com></FONT>
<BR><FONT SIZE=2>Sent: Wednesday, June 18, 2003 2:37 PM</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] A2K: Date in Query</FONT>
</P>
<BR>
<P><FONT SIZE=2>> Year(Date()). Without the (), the query thinks it's text.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Do we need an Access 101 course Darren? <evilgrin>, just kidding, I've</FONT>
<BR><FONT SIZE=2>been</FONT>
<BR><FONT SIZE=2>> nabbed about a dozen times in the past week for putting Date in a query,</FONT>
<BR><FONT SIZE=2>and</FONT>
<BR><FONT SIZE=2>> having it quote it on me...ARG! I need a vacation!</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Drew</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> -----Original Message-----</FONT>
<BR><FONT SIZE=2>> From: Darren DICK [<A HREF="mailto:d.dick@uws.edu.au">mailto:d.dick@uws.edu.au</A>]</FONT>
<BR><FONT SIZE=2>> Sent: Tuesday, June 17, 2003 10:31 PM</FONT>
<BR><FONT SIZE=2>> To: AccessD List</FONT>
<BR><FONT SIZE=2>> Subject: [AccessD] A2K: Date in Query</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Hello all</FONT>
<BR><FONT SIZE=2>> When I put msgbox Year(Date) behind a button click I get 2003. No Prob</FONT>
<BR><FONT SIZE=2>> When I put that criteria Year(Date) into a query Access changes it to</FONT>
<BR><FONT SIZE=2>> Year("Date")</FONT>
<BR><FONT SIZE=2>> and of course it fails.</FONT>
<BR><FONT SIZE=2>> What is the correct syntax to search on the 'current year' on a field that</FONT>
<BR><FONT SIZE=2>> holds that data?</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Many thanks</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Darren</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> AccessD mailing list</FONT>
<BR><FONT SIZE=2>> AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> <A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>> Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> AccessD mailing list</FONT>
<BR><FONT SIZE=2>> AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> <A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>> Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>