Problems querying oracle db from Access 2000
From: jhweb <member34971_at_dbforums.com>
Date: Mon, 04 Aug 2003 23:44:16 +0000
Message-ID: <3200808.1060040656_at_dbforums.com>
Date: Mon, 04 Aug 2003 23:44:16 +0000
Message-ID: <3200808.1060040656_at_dbforums.com>
I am trying to query a table in oracle from Access 2000 using the following criteria.
select * from table1 where DATE_RECEIVED between '1/jan/2003' and '30/jun/2003'
I am using the Oracle odbc driver.
Records should be returned but nothing.
I have tried using different formats, but nothing works.
I am new to Oracle and need some assistance on this small issue.
-- Posted via http://dbforums.comReceived on Tue Aug 05 2003 - 01:44:16 CEST