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).


--
Regards Dean

www.dkso.co.uk/
http://homepage.ntlworld.com/dkso

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]


Dkso wrote:
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).