<div>
<div class="content wysiwyg-content">
I am trying to run a simple query to update my table. Can someone tell me what syntaxt error I have here?<br />
<br />
UPDATE tbl_Moscow <br />
INNER JOIN tbl_adequacy_list ON tbl_Moscow.SPN = tbl_adequacy_list.spn_id <br />
SET tbl_Moscow.[Corporate KYC status Complete/Incomplete] = IIf([tbl_adequacy_list].[k<wbr />yc_statis_<wbr />id]=4,&quot;Com<wbr />plete&quot;,([t<wbr />bl_adequac<wbr />y_list].[k<wbr />yc_statis_<wbr />id]=5,&quot;Inc<wbr />omplete&quot;,(<wbr />[tbl_adequ<wbr />acy_list].<wbr />[kyc_stati<wbr />s_id]=10,&quot;<wbr />Sub Account&quot;,&quot;No Record&quot;)))<br />
<br />
Thanks
</div>
</div>


I am trying to run a simple query to update my table. Can someone tell me what syntaxt error I have here?

UPDATE tbl_Moscow 
INNER JOIN tbl_adequacy_list ON tbl_Moscow.SPN = tbl_adequacy_list.spn_id 
SET tbl_Moscow.[Corporate KYC status Complete/Incomplete] = IIf([tbl_adequacy_list].[kyc_statis_id]=4,"Complete",([tbl_adequacy_list].[kyc_statis_id]=5,"Incomplete",([tbl_adequacy_list].[kyc_statis_id]=10,"Sub Account","No Record")))

Thanks

VB SQl - Simple Error

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.