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)这句话有问

来源：学生作业帮助网编辑：作业帮时间：2024/05/05 06:17:47

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)这句话有问
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)这句话有问 vb select case 这个语句? VB select case is > 2 and is < 5的表示是错误的,正确的应该怎么写? 求高手指导用vb编大学物理演示实验 ADS 安装错误求大神指导,安装ADS并破解后打开出现错误 SELECT VB里面循环语句怎么用下面的公式怎么编辑?新手求指导啊判定条件是 select case 语句怎么判断在某两个值之间如题我要把 if a> 3 and a =5 and a 16 and a = 85 Grade = 优秀 Case Is > = 75 Grade = 良好 Case Is > = 70 Grade = 中等 Case Is > = 60 Grade = 及格 end Select 有错误,在vb 求指导求指导求指导, 求指导. 求指导! 求指导求指导! 求指导! 求指导求指导