select COUNT(ID) as NumberRegistered from contacts select COUNT(ID) as NumberAttending from contacts where WillAttend = 1 select SUM(AttendFootballCount) as NumberFootball from contacts where AttendFootball = 1 select COUNT(ID) as NumberGolf from contacts where AttendGolf = 1 select SUM(AttendPicnicCount) as NumberPicnic from contacts where AttendPicnic = 1 select COUNT(ID) as NumberGuestAttending from contacts where WillAttend = 1 AND GuestAttend = 1 <cfoutput>#SiteName# - #PageName#</cfoutput>

Registration Summary

View Classmate List
Registered Classmates: #NumberFormat(getNumberRegistered.NumberRegistered)#
Attending Classmates: #NumberFormat(getNumberAttending.NumberAttending)#
Attending Spouse/Guests: #NumberFormat(getNumberGuestAttending.NumberGuestAttending)#

Attending Football Game: #NumberFormat(getNumberFootball.NumberFootball)#
Attending Guys Golf: #NumberFormat(getNumberGolf.NumberGolf)#
Attending Family Picnic: #NumberFormat(getNumberPicnic.NumberPicnic)#