Select Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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