If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running a Query
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? |
#2
|
|||
|
|||
Running a Query
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. -- Build a little, test a little. "Selby" wrote: 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? |
#3
|
|||
|
|||
Running a Query
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 wrote: 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? |
#4
|
|||
|
|||
Running a Query
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! "John Spencer" wrote: 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 wrote: 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? |
Thread Tools | |
Display Modes | |
|
|