Find the most recent call

malcolm.reed

Registered User.
Local time
Today, 00:30
Joined
Jan 17, 2009
Messages
15
Hello - I'm new to this so hoping someone can help me. I'm working on a Sales Contact database, which is heavily based on the sample which came with Access 97. I've found this one to be closer to my requirements than more up to date Microsoft samples, so I've taken the old one into Access 2007 and I'm trying to bring it up to date and adapt it to our needs.

The key feature we need is call tracking. Each "contact" can have multiple "calls" attached. I'm trying to design a new query which displays a very brief summary of each contact but also includes the most recent call made to him.

I have a Query - but it shows ALL calls made to that person and I don't know how to improve it to just show the most recent.

SELECT Contacts.ContactID, Contacts.FirstName, Contacts.LastName, Contacts.StateOrProvince, Contacts.WorkPhone, Contacts.EmailName, Contacts.Owner, Calls.CallDate, Calls.CallTime
FROM Contacts INNER JOIN Calls ON Contacts.ContactID = Calls.ContactID;

Thanks in advance!
 

Users who are viewing this thread

Back
Top Bottom