Parameter Query asking me for imput twice

K

ktfrubel

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
 
J

Joan Wild

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)
 
A

Arctic77

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Query results in Form 3
How to limit Parameters 7
Report Query Parameters 2
Using Date parameters in select queries Access 2003 5
why is parameter prompting twice? 2
Parameter Queries in Crosstab Query 2
Parameter Query and Report 2

Top