Just check if below gives some guidelines :
Code:
SELECT
tblContacts.contactID,
tblContacts.contactName,
tblContacts.contactEmail,
qrySpokenContactsMaxDate.ContactID_FK,
qrySpokenContactsMaxDate.MaxOfSpokenDate,
qryMeetingsContactsMaxDate.ContactID_FK,
qryMeetingsContactsMaxDate.MaxOfMeetingDate,
qryContactsOrdersMaxDate.ContactID_FK,
qryContactsOrdersMaxDate.MaxOfOrderDate
FROM
(
(
tblContacts
LEFT JOIN
(
SELECT
tblSpoken.ContactID_FK,
Max(tblSpoken.SpokenDate) AS MaxOfSpokenDate
FROM
tblSpoken
GROUP BY
tblSpoken.ContactID_FK
)
AS qrySpokenContactsMaxDate
ON
tblContacts.contactID = qrySpokenContactsMaxDate.ContactID_FK
)
LEFT JOIN
(
SELECT
tblMeetings.ContactID_FK,
Max(tblMeetings.MeetingDate) AS MaxOfMeetingDate
FROM
tblMeetings
GROUP BY
tblMeetings.ContactID_FK
)
AS qryMeetingsContactsMaxDate
ON
tblContacts.contactID = qryMeetingsContactsMaxDate.ContactID_FK
)
LEFT JOIN
(
SELECT
tblOrders.ContactID_FK,
Max(tblOrders.OrderDate) AS MaxOfOrderDate
FROM
tblOrders
GROUP BY
tblOrders.ContactID_FK
)
AS qryContactsOrdersMaxDate
ON
tblContacts.contactID = qryContactsOrdersMaxDate.ContactID_FK;
Thanks