Rabu, 13 Januari 2016

[MS_AccessPros] IIF

 

Dear All,
Please check what wrong with my code, I didn't get the expected result. Thanks in advance.
=IIf([ItineraryRemarkTypeID]=1,ELookup("ReportText","tblReportText","ReportTextID=" & 1),IIf([ItineraryRemarkTypeID]=2,ELookup("ReportText","tblReportText","ReportTextID=" & 96,IIf([ItineraryRemarkTypeID]=3,ELookup("ReportText","tblReportText","ReportTextID=" & 97)))))
Best Regards,
Kevin


__._,_.___

Posted by: "zhaoliqingoffice@163.com" <zhaoliqingoffice@163.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar