I am attempting to retrieve data from Oracle via MS Query. A simple select works. Adding the following clause also works.

WHERE (trunc(Date_stamp)={ts '2002-03-25 00:00:00'})

Of course in the QBE grid, in the Criteria area, it look like this ->> #3/25/02#

The following also works.
Which look like [Enter Station ID] in the criteria section of the QBE.

The end I have in mind is to ask for a date to be input. When I put [Enter Date] into the criteria section of the QBE grid, the where clause becomes WHERE (trunc(Date_stamp)=?). This works fine in MS Query but will not return data to Excel. I receive the following error:
[Microsoft][ODBC driver for Oracle]Invalid scale value.

I have tried numerous other methods to get this data using statements like CDATE([ENTER DATE]), but have not yet found anything which works. I also cannot find any reasonable documentation, just some simple help.

Any help or pointers will be appreciated.