Parameter query prompts users twice

G

Guest

I created a simple parameter query, entering the text of a question,
surrounded by square brackets, in the Criteria portion of the Design view.
There is only one field that contains anything in the Criteria field.

It worked fine for a while, but now it's prompting me for the same question
twice before getting the query data.

Any hints?
 
G

Guest

In design view, go to Query, Parameters. Is there something typed in there?
If so, does it EXACTLY match what is in the criteria of the query? Even an
extra space will cause the behavior you described. If there isn't anything
typed in there, there should be but that's a different conversation.

Is the problem with just a query or a report driven by the query? If a
report, check that you don't have sorting or grouping on a non-existant field.

For testing purposes, remove the parameter from the query. Does it still
prompt you for information? If so does putting something bogus in change the
results?
 

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

Top