Oracle ODBC with Access

[Cap2010]

hi,

Through connected Oracle database with Access using ODBC.
Using access for queries on oracle through MS Access.
Whenever using certain date range query, Access outputs all data of Oracle.

How to query through MS Access with date criteria on Oracle Database using ODBC with output of those days data only

e.g.
Data is in oracle
MS Access is connected through ODBC to Oracle Database
Query thru MS Access with date range 11/1/2004 to 11/15/2004
Output required is of above date only.
Currently output is all records.

How to solve ?

Captain

 

[Turkbear]

Hi,
What have you tried already?

 

[paconc]

HI,

Try the following:
Between #11/1/2004# AND #11/15/2004#