Parameter Query asking me for imput twice

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

Guest

I have a very simple parameter query that ask for a start date and a stop
date. But when I run the query the parameter box ask both questions twice.
Could this be because the start date and stop date are 2 separte fields?
If so, How can I run a parameter query based on the information in these two
separate fields?

Thanks for your help
 
That usually happens if you don't have the prompt typed exactly the same in
the criteria row and in the Query, Parameters dialog.

If that isn't the problem, post the SQL for the query (View, SQL and
copy/paste that into a reply)
 
I have had this also if you are sorting the results. For some reason it
wants to run the query and then run it a second time to sort the reults
causing it to prompt you twice.
 
Back
Top