Access Access

Joined
Sep 23, 2009
Messages
1
Reaction score
0
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
 
Back
Top