Try different techniques in The Access Web article:
http://www.mvps.org/access/queries/qry0020.htm

Signature
HTH
Van T. Dinh
MVP (Access)
> Can anyone help make this more efficient:
>
[quoted text clipped - 14 lines]
> - OrdersKey (FK)
> - OrderStatus
Gary B - 07 May 2005 21:05 GMT
> http://www.mvps.org/access/queries/qry0020.htm
This is the second time you left this link that does not work!
gary
Douglas J. Steele - 07 May 2005 21:20 GMT
What "does not work" about that link? I just clicked on it and was taken to
the page.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
>> http://www.mvps.org/access/queries/qry0020.htm
>
> This is the second time you left this link that does not work!
>
> gary
Van T. Dinh - 07 May 2005 22:57 GMT
Try to express yourself clealy and precisely ...
"...doesn't work ..." doesn't give any info. for other people to analyze the
problem.
I am not even sure whether you cannot access the link or you tried the
techniques in the link and couldn't get your query / SQL String to work.
Either way, you should have re-posted to the original thread so that I and
other know can reply accordingly rather than re-posting the same info.
Basically, you wasted your time and my time by not following the correct
protocal / procedure in communicating through newsgroups. Perhaps, you
should read:
http://www.mvps.org/access/netiquette.htm
to learn how to use these newsgroups efficiently.

Signature
HTH
Van T. Dinh
MVP (Access)
> This is the second time you left this link that does not work!
>
> gary
Gary B - 07 May 2005 21:05 GMT
> http://www.mvps.org/access/queries/qry0020.htm
This is the second time you left this link that does not work!
gary
Gary B - 07 May 2005 21:06 GMT
> http://www.mvps.org/access/queries/qry0020.htm
This is the second time you left this link that does not work!
gary
Gary B - 07 May 2005 21:06 GMT
> http://www.mvps.org/access/queries/qry0020.htm
This is the second time you left this link that does not work!
gary
John Vinson - 08 May 2005 03:13 GMT
>> http://www.mvps.org/access/queries/qry0020.htm
>
>This is the second time you left this link that does not work!
>
>gary
And this is the fourth time you've posted this reply. Please see Van's
reply in this thread. The website is there, and it works just fine -
perhaps you might try just typing it in to your browser window rather
than clicking it, if you're having trouble getting a live link.
John W. Vinson[MVP]