Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
How to put a parameter into an Excel Query | Excel Discussion (Misc queries) | |||
parameter query help | Excel Discussion (Misc queries) | |||
Parameter Query? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |