Running a Query

[Selby]

Access 2003

I have a simple query based on three tables. It is pulling Item Number, Qty
Shipped, Invoice Number and Date Shipped. I have the criteria to Enter the
Item Number so we can see what all has shipped for that particular item.

When the Parameter value box pops up it asks for the item number. Once it
is put in, the parameter value box pops up again and asks for the item
number again. Then the query runs fine. What would be causing it to ask for
the information twice?

 

[KARL DEWEY]

Your query is probably using it twice. If you used a form to enter the Item
Number then you would not have the problem.

Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.

 

[John Spencer]

Your query is could be running twice.

If you are running the query directly and not using it as the source for a
report or form
and you have applied a sort or filter
and you have saved the sort or filter
THEN the query could run twice - once normally and then a second time to apply
the sort or filter.

An easy way to test is to copy the sql into a new query and run the new query.
If you get prompted once then you probably have the above situation.

Another possibility is that you have the parameter in twice, but have mistyped
it (two spaces between words instead of one for instance) and therefore the
query has two parameters that look very much alike but are not indentical.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Selby]

I put the sql into a new query and ran it and it only prompted me once. So
if I save this as my query then it should work, right?? Thanks so much!