A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Running a Query



 
 
Thread Tools Display Modes
  #1  
Old August 6th, 2009, 04:41 PM posted to microsoft.public.access.gettingstarted
Selby
external usenet poster
 
Posts: 57
Default 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  
Old August 6th, 2009, 05:03 PM posted to microsoft.public.access.gettingstarted
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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  
Old August 6th, 2009, 05:20 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default 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  
Old August 6th, 2009, 05:46 PM posted to microsoft.public.access.gettingstarted
Selby
external usenet poster
 
Posts: 57
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.