View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Corrine Corrine is offline
external usenet poster
 
Posts: 16
Default Parameter query question

I am trying to run a parameter query that will eventually use a cell for the
parameters. The problem I am running into is that the initial parameters
that I am using the query are not being accepted.

I have
FROM FIB_Request_Form FIB_Request_Form
WHERE (FIB_Request_Form."Create Date"=? And FIB_Request_Form."Create Date"<?)
Where the ? are coming up as prompts for Start Date and End Date.

The query works fine while I am in the Microsoft Query. But when I "return
data", I get an error message - Driver ] Parameter missing.

The parameters are not saved and I have to open Microsoft Query to change
them every time I want to run the query. When I use actual dates instead of
the prompts, it works fine.

Any help would be appreciated, Corrine