OK well maybe this might help

This is what I type in for the Value in the query

=2005/10/25 7:00 And <=2005/10/26 8:00

And this is what it does automaticly once I press enter.

=#2005/10/25 7:00:00 AM# And <=#2005/10/26 8:00:00 AM#


"Tom Ogilvy" wrote:

Try typing it in with the # signs.

Obviously the database server doesn't see what is delivered as a query as
having valid values. So I can't really address that for this approach. If
you want to do it in code, you could build the string to match what works.

--
Regards,
Tom Ogilvy


"Mike Punko" wrote in message
...
Ok the code kind of worked. It does prompt me for the date but no matter
what I type I get the error "ORA-01861: literal does not match format
string"
any ideas

My old code just to run the query was.

=#2005/10/25 7:00:00 AM# And <=#2005/10/26 8:00:00 AM#

But when I try to just type in 2005/10/25 7:00:00 for my Start date and
visa
versa for the End date I get the above error.

"Tom Ogilvy" wrote:


http://nickhodge.co.uk/gui/datamenu/...taexamples.htm

--
Regards,
Tom Ogilvy


"Mike Punko" wrote in message
...
I'm doing a Databse pull to get some information. I have the query
working
but I'd like to have the Date part of the query to be entered via a
prompt
or
enter dates into a field and press retrieve button. How do I setup
the
Query
Value to allow me to do this?