Access Access

K

kweist

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem With Bit Fields When Running Against SQL 2005 47
Comparing fields from 2 similar tables + generating new table 2
Access Access Advanced Query...Help! 0
MS ACCESS query returns empty recordset from odbc linked sql server tables 3
rewrite QBE SQL statement 4
Let MS Access do the writing/printing 2
columns to rows 2
How can I count each possible response in a report to each questio 2

Top