Re: Help with date query

How about: WHERE Month([YourField]) = 6

John Hansen wrote:
Correct. Sorry I wasn't more clear.

So you might want the data from June regardless of the year it is from?

I have a date field that is formatted mm/dd/yyyy and the data contains values
for multiple years. I want to be able to query information by month rather
than by year. Can someone tell me how to accomplish this task? Thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200710/1

.

Relevant Pages

  • Re: Use lagg(4) or Use Layer-4 Load Balancing?
    ... actually accomplished with layer-4 load balancing. ... articles and reviews that indicate that laggwill accomplish the ... teaming of multiple internet access sorces into a single logical pipe, ... You need to have multiple IP flows in order to ...
    (freebsd-net)
  • Re: Publishing Web Sites
    ... screenshots and break the single page into multiple pages ... since for various situations I'm pointing people to parts ... Tony Su ... >Either method will accomplish the same goal. ...
    (microsoft.public.windows.server.sbs)
  • Re: Avoiding Overflow
    ... I can see what you are trying to accomplish. ... 2, thus multiple by 2, then divide by 3. ... Jason Doucette / Xona.com ... Prev by Date: ...
    (microsoft.public.vc.language)
  • [opensuse] BASH: Shorter way to do [[ $line == QUIT ]] || [[ $line == Quit ]] || [[ $line == quit ]]
    ... What is a shorter way to do multiple case insensitive tests on a string or variable that would accomplish this: ...
    (SuSE)
Loading