[AccessD] Need most recent record from many

Drew Wutka DWUTKA at marlow.com
Fri Mar 28 13:45:51 CST 2003


Sorry about the archives...William is going to hold my feet to the fire to
get them back online this weekend.

As far as your issue is concerned, I would recommend Using the Max function,
however, it may work well to use a subquery.

Drew

-----Original Message-----
From: Susan Jones [mailto:susanj at sgmeet.com]
Sent: Friday, March 28, 2003 9: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


More information about the AccessD mailing list