sql server mseq: How can I retrive data from a table in MS Access database within a
specified range of date?

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


[quoted text, click to view]

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


[quoted text, click to view]