PC Review

Thread Tools Rate Thread

Re: select by month in query

Posts: n/a
      16th Feb 2004

Your query should look something like...

SELECT Year([TheDate]) AS DateYEAR, Month([TheDate]) AS DateMONTH
FROM YourTable
WHERE (((Year([TheDate]))=[Enter Year ie 2002]) AN
((Month([TheDate]))=[Enter Month Number ie 8 = August]));

Where "TheDate" is your Date column and "YourTable" is the tabl
containing the dates. This query will ask for the year first and the
the Month Number.


~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Avg. 1-month, 3-month, 6-month & 12-month Stock Returns ryguy7272 Microsoft Access Queries 2 7th Feb 2010 04:28 PM
Select all dates in month from month and year in text box? LeeZard via AccessMonster.com Microsoft Access Queries 1 3rd Mar 2008 05:38 PM
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? misscrf Microsoft Excel Misc 1 14th Dec 2007 03:59 PM
Print Current Month with last month and next month in Header JMoore0203 Microsoft Outlook Calendar 1 5th Dec 2007 05:15 PM
printing Little Current month and Little Next month on Banner when it should little PRIOR month and little Next month. jake_allen10@hotmail.com Microsoft Outlook 0 3rd Nov 2006 08:30 PM




All times are GMT +1. The time now is 09:19 AM.