Microsoft Query: Parameter Query?

[Abel MacAdam]

Hi,

In Excel I have a connection to a database. This connection uses a Query. In
this query I want to add parameters that will change. For instance, I want
the query to return only rows of data between a 'start' and a 'finish' date.
How can I accomplish that?

Microsoft Help talks over "parameter query (parameter query: A type of query
that, when you run it, prompts for values (criteria) to use to select the
records for the result set so that the same query can be used to retrieve
different result sets.)." I could not find where or how I can accomplish that.

Abel.

 

[Abel MacAdam]

I found the Parameters button. But it is greyed out. So I can't use it.

I followed the instructions in the Microsoft article
http://office.microsoft.com/en-us/excel/HP102161131033.aspx

Next to a
- Edit Query... button
I see a greyed out
- Paramaters button.

What can I do to be able to use this button?

 

[Abel MacAdam]

Answering my own questions <%-{

In my query, I had something like:
WHERE start <= T.Created
AND T.Created <= finish

Excel complained it dit not know start (and finish). But when I entered
question marks, like
WHERE ? <= T.Created
AND T.Created <= ?
I could enter the Parameters, and Excel asked my to input the required
dates. Now I only have a problem with the format of the dates.