Using two tables and getting the most upto date value from one table

[ymustiregister]

Hi,

I have a two tables in access. I am using 2003.

First table is like this

Code,Description
1000,Something
2000,Otherthing

Second table

Code,Comment,Date
1000,Yeah,02/07/07
1000,Blah,04/07/07
2000,No,02/06/07
2000,Other,07/07/07
1000,Blah2,06/07/07


Now when I do a query I want to get a summary of both tables with the
code,description, most recent comment for the code and date.

Therefore the result of the query should be:

Code,Description,Comment,Date
1000,Something,Blah2,06/07/07
2000,Otherthing,Other,07/07/07

Any help would be appreciated.

Thanks.

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

If using subqueries is new, see:
http://allenbrowne.com/subquery-01.html

 

[Joan Wild]

Look for 'Getting a related field from a GroupBy query' in the queries section of
www.mvps.org/access