Carlos, you rule! I've been trying to figure out how to do this FOREVER!
Thanks so much for the tip!

"CarlosAntenna" wrote:

Dave,

I just figured this out for myself last week because I got no answer here.
Maybe I just didn't ask the right question.

In MS Query go into the "Value" field right below the "Criteria Field".
Enter a pair of square brackets with a prompt in between [your prompt here].
Then when the query runs a box pops up asking for the value.

If you want it to refer to a cell in the spreadsheet you can right click
somewhere in your retrieved data then choose "Parameters" from the context
menu. Select "Get Value from Cell" and enter the cell reference.

Carlos

"Dave Y" wrote in message
...
Hello,

I have a Microsoft Query that connects to an Oracle DB and
bring the data results into an Excel spreadsheet. The
query runs fine and brings in the correct data, but my
issue is this; currently the SQL in the query is set to
bring in the data from SYSDATE-1. How can I change things
so that the user can type the desired date in a cell (for
example Cell A1)in the Excel spreadsheet and then click
Refresh Data to bring in the data from that date? There is
no graphical representation for this query so is there a
way for me to reference the cell the date is entered into
in my SQL code? Any help will be greatly appreciated,
thank you.

Dave Y