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