Select case problem

Jeg har en database med feltet "Attending" og på en side skal jeg vise indholdet. Der er 3 mulige indhold i feltet, som jeg vil vise med flg. Select Case script:

Select Case Attending
Case "AttendingBOTH"
    strAttending = "Deltager begge"
Case "AttendingHR"
    strAttending = "Deltager HR"
Case Else
    strAttending = "Deltager ikke"
End Select

Problemet er, at scriptet konstant viser "Deltager ikke" selv om jeg har valger en datarække hvor indholdet i feltet er "AttendingBOTH" eller "AttendingHR"

Hvad har jeg gjort forkert?

Min SQL-kode:
strSQL= "SELECT Participants.ParticipantID AS Participants_ParticipantID, Participants.Attending, Participants.Firstname, Participants.Lastname, Participants.Title, Participants.Department, Participants.Country, Participants.Telephone, Participants.Mobilephone, Participants.Email, Participants.Nationality, Participants.Call_me, Participants.Reports_to, Participants.Job, Participants.Projects, Participants.LeisureInterests, Participants.Registrationdate, ArrivalDetails.ArrivalDate, ArrivalDetails.ArrivalHour, ArrivalDetails.ArrivalMinute, ArrivalDetails.ArrivalBy, ArrivalDetails.ArrivalFlightNo, ArrivalDetails.TransferToHotel, DepartureDetails.DepartureDate, DepartureDetails.DepartureHour, DepartureDetails.DepartureMinute, DepartureDetails.DepartureBy, DepartureDetails.DepartureFlightNo, DepartureDetails.TransferToAirport, RoomReservation.RoomRequired, RoomReservation.Checkin, RoomReservation.Checkout, RoomReservation.RoomPreference, RoomReservation.DiateryRemarks, RoomReservation.DiateryPreferences FROM ((Participants INNER JOIN DepartureDetails ON Participants.ParticipantID = DepartureDetails.ParticipantID) INNER JOIN RoomReservation ON Participants.ParticipantID = RoomReservation.ParticipantID) INNER JOIN ArrivalDetails ON Participants.ParticipantID = ArrivalDetails.ParticipantID WHERE Participants.ParticipantID=710"