查询NULL

Henry D. Sy

Dannyclock 发表于 2017-7-14 10:11
好,已经上传了,谢谢,就在Data Query裡面有一个栏位"ORDER TYPE".因为资料是从另外一个系统拿出来的,所以 ...

1. SELECT Data.[File number], Data.Subdepartment, Mid([Subdepartment],4,2) AS Code, Data.[B/L type], Data.Sector, Data.Mode, IIf(Len(Trim([Order type]))=0,"NIL",[Order type]) AS OrderType, Data.[Chargeable Weight], Data.Volume, Data.Weight, Data.TEUs, Data.[Responsible Employee Name], Data.[Balance in National Currency], Data.[Accrued expenses in National Currency], Data.[Accrued revenue in National Currency], Data.[Expense in National Currency], Data.[Revenue in National Currency]
   
2. FROM Data;
   

复制代码

Henry D. Sy

1. IIf(Len(Trim([Order type]))=0,"NIL",[Order type]) AS OrderType

复制代码

Dannyclock

谢谢大家帮忙