VB错误,求指导select cangwei,qty,storenu,outofplace from YUCHUKU where chukunu='AA123456' and (cangwei='' or cangwei is null or qty=0 or qty='' or qty is null or storenu='' or storenu is null or outofplace='' or outofplace is null)这句话有问题,报错标准表达式中类型不匹配谁帮我纠纠错啊本意是指,从YUCHUKU里查询4列是否有空值,满足条件CHUKUNU=AA123456上面的问题我自己解决了,有2张ACCESS表A表字段有a,b,c,d,e(e是数字)B表字段有f,g,h,i(i是数字)现在我想要当A.a=B.f and A.b=B.g and A.c=B.h的时候,A的e字段减去B的i字段,然后更新掉A的e字段.即最后结果为A的e=e-i这句话我要怎么写啊

问题描述:

VB错误,求指导
select cangwei,qty,storenu,outofplace from YUCHUKU where chukunu='AA123456' and (cangwei='' or cangwei is null or qty=0 or qty='' or qty is null or storenu='' or storenu is null or outofplace='' or outofplace is null)
这句话有问题,报错标准表达式中类型不匹配
谁帮我纠纠错啊
本意是指,从YUCHUKU里查询4列是否有空值,满足条件CHUKUNU=AA123456
上面的问题我自己解决了,
有2张ACCESS表
A表字段有a,b,c,d,e(e是数字)
B表字段有f,g,h,i(i是数字)
现在我想要当A.a=B.f and A.b=B.g and A.c=B.h的时候,A的e字段减去B的i字段,然后更新掉A的e字段.
即最后结果为
A的e=e-i
这句话我要怎么写啊

select cangwei,qty,storenu,outofplace from YUCHUKU where chukunu='AA123456' and (cangwei='' or isnull(cangwei) or qty=0 or isnull(qty) or storenu='' or isnull(storenu) or outofplace='' or isnull(outofplace))