Most recent record

[Pic]

My database consists of 2 tables. CONTACTS and MEETINGS.

CONTACTS contains name fields (FName, LName), address fields, etc..
Key field is CONTACTID.

MEETINGS contains info about meetings I've had with each contact: date
of meeting, place, time topic. One of the fields is a memo field. Key
field: MEETINGID.

The tables are related by CONTACTID.

I would like to create a query that returns the name of each of my
contacts (alphabetized on last name) and all the info from my most
recent meeting with that contact.

Any help would be greatly appreciated.

Thanks in advance,
Pic

 

[Pic]

Forgot to mention I am using Access 2003.

 

[Allen Browne]

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

If subqueries are a new idea, here's some more examples:
http://allenbrowne.com/subquery-01.html