[AccessD] Need most recent record from many

Susan,

I assume you have a date field on the many side.  If so then
Max(datefield) will get the latest date.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



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