Select Query

P

Pago

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.
 
C

coder23

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.
 
P

Pago

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