I am new to access but have 3 tables linked by ID that I would like to write a query that returns multiple responses in 1 field.
LPG - Operating Loans: IIf([t_KYC_Checklist]![GI LPG BMO Chicago]=True,"General Information",elseIIf([t_kyc_cip]![CIP LPG BMO Chicago]=True,"Connection",elseIIf([t_kyc_Fund_information]![fi LPG BMO Chicago]=True,"Fund"," ")))
but in a query I am unable to do this how could I write this to get all 3 answers if all 3 ifs are true
LPG - Operating Loans: IIf([t_KYC_Checklist]![GI LPG BMO Chicago]=True,"General Information",elseIIf([t_kyc_cip]![CIP LPG BMO Chicago]=True,"Connection",elseIIf([t_kyc_Fund_information]![fi LPG BMO Chicago]=True,"Fund"," ")))
but in a query I am unable to do this how could I write this to get all 3 answers if all 3 ifs are true