Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / May 2005

Tip: Looking for answers? Try searching our database.

Query Help Again...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gary B - 07 May 2005 05:08 GMT
Can anyone help make this more efficient:

SELECT Orders.OrdersKey, (Select Top 1 OrdersHistory.OrderStatus From
OrdersHistory where OrdersHistory.OrdersKey = Orders.OrdersKey Order By
OrdersHistoryKey DESC) AS LastStatus
FROM Orders

-------------------------------------------------

Table Orders
- OrdersKey (PK)
- OrderDate
- etc.

Table OrdersHistory
- OrdersHistoryKey (PK-AutoNumber)
- OrdersKey (FK)
- OrderStatus
Van T. Dinh - 07 May 2005 10:39 GMT
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]    
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.