|
Microsoft Query Help
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 |
You're welcome, Patti. Glad I could help.
Carlos "Patti" wrote in message ... 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 |
Carlos thanks a million I was trying to get this right for ages, the weird
pard is that is so simple... Thanks a million Antonio Ramos "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 |
Great page Nick. Where were you when I was looking for this a couple of
months ago? <VBG Carlos "Nick Hodge" wrote in message ... Antonio You might look here http://www.nickhodge.co.uk/gui/datam...taexamples.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Antonio Ramos" <Antonio wrote in message ... Carlos thanks a million I was trying to get this right for ages, the weird pard is that is so simple... Thanks a million Antonio Ramos "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 |
| All times are GMT +1. The time now is 04:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com