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



Member Interest Preference Date Completed
style="color:white;" >Primary Color: #GetMembers.PrimaryColor#
  Click to display their profile report. Click to send this member an e-mail. #GetMembers.LastName#, #GetMembers.FirstName# style="color:white;" >#GetMembers.GroupAssigned# #DateFormat(GetMembers.DateFinished, 'mm/dd/yy')#
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