Microsoft Query: Parameter Query?

  • Thread starter Thread starter Abel MacAdam
  • Start date Start date
A

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.
 
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.
 
Back
Top