Display Paramater value in a cell
Hello. I have a worksheet that imports external data from a MS Access
database using paramaters. I have it set up to prompt the user for the starting date and ending date for the report when it is opened. What i want to do is have 2 other cells return the dates that were entered in for the paramaters. Anybody help me out? |
Display Paramater value in a cell
Are you running a macro? How are you prompting the User for inputs if not a
macro. the macro can easily be modified if you post ift to write the dates to a cell. "cyb3rwolf" wrote: Hello. I have a worksheet that imports external data from a MS Access database using paramaters. I have it set up to prompt the user for the starting date and ending date for the report when it is opened. What i want to do is have 2 other cells return the dates that were entered in for the paramaters. Anybody help me out? |
Display Paramater value in a cell
No, I am not running a macro. I have it set up in MS Query for the "Date"
criteria to be "= [Start Date] And <= [End Date]". And then i have excel set to prompt for the parameter. What i am trying to do is have 2 other cells in excel return the values for [Start Date] and [End Date]. I realize that it can get the paramater values from a cell or cells, but for my purposes, that isn't what i want to accomplish, I want to do the opposote; have 2 different cells return the values. "Joel" wrote: Are you running a macro? How are you prompting the User for inputs if not a macro. the macro can easily be modified if you post ift to write the dates to a cell. "cyb3rwolf" wrote: Hello. I have a worksheet that imports external data from a MS Access database using paramaters. I have it set up to prompt the user for the starting date and ending date for the report when it is opened. What i want to do is have 2 other cells return the dates that were entered in for the paramaters. Anybody help me out? |
Display Paramater value in a cell
You could setup a macro to input the Start and End Dates. The macro would
put the value into the cells you want and also put these values into the Query. "cyb3rwolf" wrote: No, I am not running a macro. I have it set up in MS Query for the "Date" criteria to be "= [Start Date] And <= [End Date]". And then i have excel set to prompt for the parameter. What i am trying to do is have 2 other cells in excel return the values for [Start Date] and [End Date]. I realize that it can get the paramater values from a cell or cells, but for my purposes, that isn't what i want to accomplish, I want to do the opposote; have 2 different cells return the values. "Joel" wrote: Are you running a macro? How are you prompting the User for inputs if not a macro. the macro can easily be modified if you post ift to write the dates to a cell. "cyb3rwolf" wrote: Hello. I have a worksheet that imports external data from a MS Access database using paramaters. I have it set up to prompt the user for the starting date and ending date for the report when it is opened. What i want to do is have 2 other cells return the dates that were entered in for the paramaters. Anybody help me out? |
All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com