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



Member Primary Energy Date Completed
style="color:white;" >ICS Color Preference: #GetMembers.GroupAssigned#
  Click to display their profile report. Click to send this participant an e-mail. #GetMembers.LastName#, #GetMembers.FirstName# style="color:white;" >#GetMembers.PrimaryColor# #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