Running a Query


S

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?
 
Ad

Advertisements

K

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.
 
J

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
 
Ad

Advertisements

S

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!
 

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