I was able to figure this out myself - I had to use the CASE statements in the SELECT clause.

SELECT CS_Survey.Survey_Name AS Type, Config.Serial_Number, Config.Date_Purchased, Config.Date_Expiration AS Warranty_Until,

Config.Tag_Number, Contact.First_Name, Contact.Last_Name,...