Input Control
 

Hello,

I have a worksheet that contains a query the bring me back info based on est
completion time is equal to or less than the date specified in the query.
What I want to do is place an input box in the sheet and have the user enter
a date and bring back the info based on whatever date they choose...can some
one help me with this??

Thank you so much..

One of the users in this forum taught me how to do this! Set up the query as
a parameter query -- in the criteria section, enter:

[Enter date]

When the query is run, it will ask for the date. Enter a date, run the
query and return the results to Excel.

Then right click in the results section, select Parameters. Hilight the
parameter name of Enter Date, and click the button that says Get the value
from the following cell. Enter the cell that will contain the date.

Hope this helps!

"Dmorri254" wrote:

Hello,

I have a worksheet that contains a query the bring me back info based on est
completion time is equal to or less than the date specified in the query.
What I want to do is place an input box in the sheet and have the user enter
a date and bring back the info based on whatever date they choose...can some
one help me with this??

Thank you so much..

Thanx Patti..will try and see if it works..

david

"Patti" wrote:

One of the users in this forum taught me how to do this! Set up the query as
a parameter query -- in the criteria section, enter:

[Enter date]

When the query is run, it will ask for the date. Enter a date, run the
query and return the results to Excel.

Then right click in the results section, select Parameters. Hilight the
parameter name of Enter Date, and click the button that says Get the value
from the following cell. Enter the cell that will contain the date.

Hope this helps!

"Dmorri254" wrote:

Hello,

I have a worksheet that contains a query the bring me back info based on est
completion time is equal to or less than the date specified in the query.
What I want to do is place an input box in the sheet and have the user enter
a date and bring back the info based on whatever date they choose...can some
one help me with this??

Thank you so much..