If this were MS-SQL you'd need to use DatePart ----- Original Message ----- From: "noel estabrook" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 15, 2003 2:10 PM Subject: Witango-Talk: Easy Question: doing date queries
> Hard to believe I've never run into this before, but... > > I want to do a query on a Data/Time field (Access). I want to get > records where the date is of a certain month and/or a certain year. > But when I go to build the search action, all of the Begins With, > Contains and Ends with functions are all grayed out. Short of doing > a straight SQL query, is there any way to accomplish such a thing? > > TIA. > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
