Re: MS Access query

Typically, you will get a better response by posting to one of the numerous
microsoft.public.access newsgroups.

Something like this in the WHERE clause should return values in October:

WHERE MyDateColumn >= #2006/10/01# AND MyDateColumn < #2006/11/01#

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


<debrajpramanik@xxxxxxxxx> wrote in message
news:1164022418.090127.207860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
How can I retrive data from a table in MS Access database within a
specified range of date?



.

Relevant Pages

  • Re: MS Access query
    ... you will get a better response by posting to one of the numerous ... microsoft.public.access newsgroups. ... Something like this in the WHERE clause should return values in October: ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Some English usage questions
    ... for your judgment, Bob Cunningham did, so please tell him and not me. ... When I feel that I need an English teacher, I will find one on my own, ... posting from Taiwan. ...
    (alt.usage.english)
  • Re: Red Light Offence Appeal
    ... I was caught back in February going through a red light. ... Presumably you showed the same powers of judgment and observation that lead ... to you posting this same fuckwitted enquiry to multiple newsgroups? ...
    (uk.transport)
  • Re: sp4 and corruption
    ... the quality of the responses received is related to our ability to ... Don't post to multiple newsgroups. ... Most good judgment comes from experience. ... windows 2000 advanced server failover cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Help for SQl setup?
    ... the quality of the responses received is related to our ability to ... Don't post to multiple newsgroups. ... then use your newsreader's capability of multi-posting, i.e., posting one ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.setup)