在access中如何做查询 ,如下:
select sum(0-B.XSJE) As XSJE
FROM A
查询的结果为空,然后返回结果呢?
如果在MS SQL SERVER 可以如下使用,那就没有问题了,
select isnull(sum(0-B.XSJE),0) As XSJE
FROM A
那么在access中有类似的方法吗?
select sum(0-B.XSJE) As XSJE
FROM A
查询的结果为空,然后返回结果呢?
如果在MS SQL SERVER 可以如下使用,那就没有问题了,
select isnull(sum(0-B.XSJE),0) As XSJE
FROM A
那么在access中有类似的方法吗?
if qry.fieldbyname('XSJE').asfloat=0 then
判断记录可以用 if AdoQuery1.RecordCount < 1 then ...
如果你要像SQL Server一样就用IIF
select sum(0-IIF(ISNULL(B.XSJE), 0, B.XSJE)) As XSJE FROM A