[AccessD] select most recent

Drew Wutka DWUTKA at marlow.com
Tue Feb 18 16:27:01 CST 2003


Quite frankly I haven't touched a book about Access or even remotely
computer related since I started using Access.  I had a 'basic' Access book,
that I used to figure out where to start looking in the help files, and from
then on....no more books.  (With one exception.  I did check out a book on
C++ this past summer from the library....so that's 1 book (about computer
stuff) in almost 5 years.).
 
It's not like I learn by magic, my resources are 'Trial and Error' (probably
the biggest chunk...hehehehe), Access 97 help files (next in line), the MSDN
(The version I have is what came with Access 2000 Developer's edition...3
CD's, plenty of stuff), then a lot of online resources, like the List, The
Access Web ( http://mvps.org/Access <http://mvps.org/Access> ),
comp.databases.ms-access (though that has gone down hill a bit lately), and
lately Woody's lounge.
 
Lately I have been doing more 'contributing' then asking, but I learn just
as much as I contribute from just reading other posts.  For example, the
proposed solution I gave you is something I have never done in any of my own
projects.  It just so happens that I had a post on a similar issue on
Woody's lounge, that i solved using the subquery method...which is something
I just remember reading about somewhere (can't remember where to be
truthful), so I looked it up in Access 97's help files, and whalla.  Right
after I posted to the lounge, I read your last post, so I posted a modified
version for you.
 
I am not recommending that you forsake 'book knowledge', I just can't give
you any good titles.
 
Drew

-----Original Message-----
From: Eric Goetz [mailto:EricGoetz at egisystems.com]
Sent: Tuesday, February 18, 2003 12:55 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] select most recent



Hi Drew,

 

Wow! It's like magic. I would never have come up with this, especially the
part "TerritoryID=T1.TerritoryID". I still don't really understand how it
works. I've looked through all my books, but it seems my library needs
another book (to the astonishment of my wife!) Will you please suggest a
book that explains this type of query?

 

Thanks,

 

Eric

 

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Monday, February 17, 2003 9:33 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] select most recent

 

Okay, I built tblTest.  It has ManagerID, TerritoryID and DateAssigned as
you have below.  Then I used this SQL statement to produce the results you
want:

 

Select ManagerID, TerritoryID, DateAssigned


More information about the AccessD mailing list