Display Paramater value in a cell

[cyb3rwolf]

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?

 

[Joel]

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]

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]

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.

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.

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.