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,


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:

Posting Komentar