I am being prompted to enter the same supplier with my query twic.

[Guest]

I am being prompted to enter the same supplier with my query twice. Does any
one how to stop this and why does it occur?

Thanks

 

[Steve Schapel]

Douglas

Could you please tell us something about your query? If you go to the
design view of the query, and select SQL from the View menu, you could
copy/paste the SQL view of the query into your post. It might also be
relevant to tell us when the problem behaviour happens, for example when
you try to print a report based on the query.

 

[John Vinson]

On Wed, 8 Sep 2004 00:33:05 -0700, "Douglas Tubbs" <Douglas

I am being prompted to enter the same supplier with my query twice. Does any
one how to stop this and why does it occur?

Thanks

Please open your query in SQL view and post the SQL text here.
Actually first doublecheck that the two prompts are EXACTLY the same:

[Enter Supplier:]

and

[Enter Supplier:]

are NOT the same prompt and you'll get both.

John W. Vinson[MVP]
(no longer chatting for now)