查询NULL

Henry D. Sy

Dannyclock 发表于 2017-7-13 15:42
NZ好像不行,因为这栏位本身就是空白的,我是加了一个新的栏位在查询裡面,之后看看ORDER TYPE是不是空白的, ...

估计,实际不为空,而是空字符串

Henry D. Sy

如果真为空
Nz([ORDER TYPE],"NIL")即可

Henry D. Sy

Dannyclock 发表于 2017-7-14 09:58
谢谢,你这个字串要放在那?

你最好传上例子,否则大家只能靠猜

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

复制代码