If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Select Query
Whenever I design a select query, I have to enter the parameter twice before the query runs. It seems like the first time I run the query after I saved the query, I only have to enter the parameter once but after that I have to enter it twice. What am I doing wrong.
|
#2
|
|||
|
|||
Select Query
In Design View,
try deleting any unused blank columns in the Design Grid..... then save the query. Close out of the query. The next time you run it, it should only ask once. |
#3
|
|||
|
|||
Select Query
Thank you coder23. Your fix worked. I have been dealing with this for a long time and could never find a solution in the Microsoft manuals. BTW, I have some "select queries" with blank columns that work OK but who cares as long as I could fix the problem queries.
----- coder23 wrote: ----- In Design View, try deleting any unused blank columns in the Design Grid..... then save the query. Close out of the query. The next time you run it, it should only ask once. |
Thread Tools | |
Display Modes | |
|
|