SELECT teammembers.*, participants.DateFinished FROM teammembers, participants WHERE TeamID = '#Client.TeamID#' AND (participants.ID = teammembers.ParticipantID) ORDER BY participants.DateFinished DESC, teammembers.LastName, teammembers.FirstName ICS-CONNECT ADMINISTRATION - COMPLETED MEMBERS BY DATE TAKEN



Member Primary Energy Interest Preference
COMPLETED: #DateFormat(GetMembers.DateFinished, 'mm/dd/yy')#
Click to display their profile report. Click to send this participant an e-mail. #GetMembers.LastName#, #GetMembers.FirstName# style="color:white;" >#GetMembers.PrimaryColor# style="color:white;" >#GetMembers.GroupAssigned#
Total Members: #NumberFormat(GetMembers.RecordCount, '999,999')#
LEGEND:   Click on this icon to send an e-mail to the contact for that project. - E-mail to Member Link     Click on this icon to display this person's profile report - Display Profile Report