select uid,thedate,name from theTable where month(thedate) = 8
Sorry, I ain't to bright sometimes.
Robert.
On Friday, August 15, 2003, at 03:05 PM, Robert Garcia wrote:
If access suports this, you could do a custom column, or direct dbms action like this, assuming a table of three columns uid,thedate,name:
select uid,thedate,name where month(thedate) = 8
That will give you all of august of every year.
Robert.
On Friday, August 15, 2003, at 02:10 PM, noel estabrook wrote:
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
--
Robert Garcia President - BigHead Technology CTO - eventpix.com 2781 N Carlmont Pl Simi Valley, Ca 93065 ph: 805.522.8577 - cell: 805.501.1390 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
--
Robert Garcia President - BigHead Technology CTO - eventpix.com 2781 N Carlmont Pl Simi Valley, Ca 93065 ph: 805.522.8577 - cell: 805.501.1390 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
