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