why does my parameter query repeat the prompt?

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

Guest

I have a query with three parameters. The query asks for each parameter and
then repeats itself before returning the data.
 
Probably because the query is being run more than once -- perchance, is this
query the RecordSource of a subreport or subform?
 
OR have you applied a filter or sort on the query while in datasheet view
and then saved the change? If so, open the query and select Remove
Filter/Sort from the menu and then save the query. Now try running the
query again.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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

Parameter Query Won't Run 0
Parameter query prompts twice 2
SQL Select Query Prompting for NonExistent Parameter 8
Multiple Parameter Crosstab query filter by form 1
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Parameter Queries in Crosstab Query 2
query parameters 2
Modify Parameter Query 1

Back
Top