2009年7月17日星期五

ACCESS - 多個條件方法

以下是學生的問題
如果資料欄位內的身分字號同時包含居留證號(居留證號的第二碼英文字若為”A”或“c”則為男性,”B”或“D”則為女性,)請問該如何下條件抓取性別資料?


性別: IIf((IIf(Mid([字號],2,1)="C",1,0)+IIf(Mid([字號],2,1)="A",1,0)+IIf(Mid([字號],2,1)="1",1,0))=1,"男","女")

1 评论:

匿名 说...

After looking into a few of the blog posts on your blog,
I seriously appreciate your way of blogging. I saved as
a favorite it to my bookmark webpage list and will be checking back soon.
Please visit my web site as well and let me know how you feel.
My website :: ridiculously photogenic guy

 
妹咕數位學園歡迎網友們來信指教 妹咕信箱