Why does my query ask multiple times for each parameter?

[sueb]

Well, once again you're right, NeoPa!

Removing and replacing that text made it work correctly again. How ever did you even stumble on this?? What made you think of trying that?

[NeoPa]

When objects are creeated based on text strings (as queries are) they sometimes get out of synch, so a reboot fix is to type the string in again. In this instance it worked ;-)

[sueb]

Wow. So that's something I'll tuck away to remember for future bizarre query problems. Thanks, NeoPa!

[JDyer]

There are cases where this occurs when the parameter criteria is not used with the Where for the fields used with your params.

[NeoPa]

I'm afraid that you seem to have the wrong end of the stick entirely. That is clearly not the issue in this case, as has already been demonstrated by the existing posts in the thread.

We don't have rules against resurrecting old threads per se, but please read through them before offering advice that may be inappropriate, as this seems to be. Bear in mind also that a picture of the query in design view is not too helpful when much of the information is truncated. Typically we use the SQL of a query as that encapsulates all the logic completely.

The issue here was found to be a glitch or corruption in the database, and not related to any faulty SQL. When the SQL was re-applied, exactly as it was originally, it worked fine. Clearly there was nothing wrong with the original SQL itself.