Oracle ODBC with Access

[Cap2010]

Hi,

Currently using MS Access Query to retreive data from Oracle database thrugh ODBC.

The query is retrieves all data for a date range given.

Requirement is to retrieve only those data with a date range given.

Please help

Cap

 

[zemp]

Look into the 'between' SQL key word. I think that you are looking for something like,

SELECT * FROM Table1 WHERE TheDate BETWEEN Date1 AND Date2

Syntax needs to be verified.

Also, this is more of an SQL question. You probably won't get many responses in this forum. You might want to make sure that you post in the SQL forum of the tool you are using. (Access/Jet SQL).

zemp

 

[Cap2010]

Yes this is right, only things is on giving dates for date1 and date2 it displays all records.

date1 = 11/1/2004
date2 = 11/10/2004

Captain

 

[zemp]

Try surrounding the dates with the '#'. That's Access SQL syntax.

SELECT * FROM Table1 WHERE TheDate BETWEEN #Date1# AND #Date2#

How are you building your SQL? Is the concatenation correct? Try posting the relevant code.

zemp

 

[Cap2010]

I am trying to do it using Query mode given in MS Access and not through module.

Cap2010

 

[zemp]

Try forum701.

zemp