如果没有通过查询找到，则需要0 [英] Require 0 if none found via query

问题描述

我有一个我想要查询的表ACT_TYPE_SC，它有很多可能性，但我想检查某些标准，即延迟一词。如果没有找到，则返回零，因为稍后使用。我已经尝试过Nz，Isnull却只能获得一个空白空间，请帮助完整的新手！谢谢

尝试;

展开 | 选择 | Wrap | 行号

解决方案

尝试：

展开 | 选择 | Wrap | 行号

您好，感谢您的快速响应，附上的是SQL（Mod - 已删除的附件，并在后）。其中对ISO Workday的引用是关于日期的另一个查询。提前谢谢，因为我花了好几天时间。 :-(

展开 | 选择 | Wrap | 行号

FishFace：

对ISO Workday的引用是另一个关于日期的查询。

???我唯一看到的远程接近代码中的ISO Workday看起来不像查询引用。 ISO_WorkdayDiff（[INC_CLOSE_DATE]，[DATE_LOGGED]，True）似乎是某种函数。

Hi, I have a table ACT_TYPE_SC that I am trying to query, it has many possibilities but I want to check for certain criteria ie the word "Delay" and if none are found return a zero as this is used later on. I have tried Nz, Isnull but can get no joy only a blank space, please help the complete novice !! thanks
Attempts;

Expand|Select|Wrap|Line Numbers

解决方案

Try :

Expand|Select|Wrap|Line Numbers

Hi, thanks for quick response, attached is the SQL (Mod - Removed attachment and included the code properly in the post). the reference to ISO Workday in it is another query regarding dates. Thanks in advance as I have spent days on this. :-(

Expand|Select|Wrap|Line Numbers

FishFace:
The reference to ISO Workday in it is another query regarding dates.

??? The only thing I see remotely close to "ISO Workday" in your code doesn''t look anything like a query reference. ISO_WorkdayDiff([INC_CLOSE_DATE],[DATE_LOGGED],True) appears to be a function of some sort.

这篇关于如果没有通过查询找到，则需要0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！