Dear Sirs,
I have the following select query and i need to update the field
EmailLastReceivedDate (showing null in the select) to the values in the
field MaxOfSentOn using access 2000 query
OFCOURSE ONE STATMENT NOW I HAVE A LOOP THRU THE RECORDSET AND A UPDATE
ACCORDINGLY
SELECT Max(EmailsDatabase.SentOn) AS MaxOfSentOn, CoEmails.CoCode,
CoBank.EmailLastReceivedDate
FROM (EmailsDatabase INNER JOIN CoEmails ON EmailsDatabase.From =
CoEmails.Email) INNER JOIN CoBank ON CoEmails.CoCode = CoBank.Code
GROUP BY EmailsDatabase.From, CoEmails.CoCode,
CoBank.EmailLastReceivedDate;
MaxOfSentOn CoCode EmailLastReceivedDate
8/30/2005 12:49:51 PM 37
4/5/2005 11:35:34 AM 10
9/16/2005 6:36:53 AM 81
Any help would be much apreciated,
Thank you
*** Sent via Developersdex http://www.developersdex.com ***