[AccessD] Need most recent record from many

Similar questions have come up before.  I believe that what is required to
do this is a correlated sub-query.  There is an example on my much neglected
web site, www.goodhall.info/steve.  Click on the "Useful Software" button
and scroll down to the last item on the page.  While this does not
specifically address the question of dates, the basic technique will do what
you want.  I may have a date specific example somewhere in my files.  If I
find it, I will send it along.

Now that I have finished my Master's degree, I suppose I could find some
time to update the web site.

Regards,

Steve Goodhall

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Jones
Sent: Friday, March 28, 2003 10:09 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Need most recent record from many


I hope this is so easy I'll be embarrassed I even asked, but...
I have a query that links two tables with a one-to-many relationship.  My
problem is that I want to pull only the most current record on the many
side.  I know this has to be something easy, but I'm either blind to it or
just not able to figure out where to start looking.  I tried to access the
archives, but the link takes me to the mail options page.
Thanks!
Susan

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com