I opened up a query in SQL view and here is what I saw:
SELECT
    tbl_Participants.RiderID,
    [FirstName] & " " & (" """ + [NickName] + """") AS Member,
    tbl_Participants.LastName,
    tbl_Participants.Email,
    tbl_Participants.ContactNumber,
    tbl_Participants.MotorcycleOwner
FROM...