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#
#GetMembers.LastName#, #GetMembers.FirstName#
style="color:white;"
>#GetMembers.PrimaryColor#
#DateFormat(GetMembers.DateFinished, 'mm/dd/yy')#
Total Members: #NumberFormat(GetMembers.RecordCount, '999,999')#
LEGEND:
- E-mail to Member Link
- Display Profile Report