Date or datetime

D

Dkso

I connect to an Oracle DB in MS Excel query. The format of the datetime
field in the DB is:-
2003-07-16 20:03:32

I want to be able to produce a prompted query from Excel I understand that
the user can enter data into a cell and refresh the query, which will use
the entered data as it's criteria.
How do I do this?

I want the user to enter two DATES (not Date Time or possibly date and
00:00:00)as a between (Start and End dates).
 
J

Jake Marx

Hi Dean,

I'm not sure if it will work with Oracle, but maybe you can try using a "?"
in the SQL Statement, which should force MS Query to prompt for a parameter
value. For example:

SELECT * FROM tblData WHERE DataID > ?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Top