I found what you were talking about (with a little help) but I'm not entirely sure what needs to be changed. I'm seeing this:
Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved,
--u.FirstName + ' ' + u.LastName as UserName,
u.DisplayName as UserName, u.Email,
s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved,
...and I'm thinking that DisplayName needs to be changed to something but it looks like it is supposed to be displaying UserName and Email.
I'm not terribly familiar with SQL so forgiveme if these questions are silly. I'm getting input from another person who is more experienced with this.
Thanks