查询中计算字段的标准 [英] Criteria for a calculated field in a query

问题描述

嗨！


我需要帮助我应该放置什么标准，以便我的查询显示其中的记录（计算字段的字段名称）=是（它是是/否格式）


这是我计算的字段表达式：

Hi!

I need help on what criteria should I put in order for my query to display records where Within(fieldname of the calculated field) = Yes (it''s a Yes/No format)

This is my calculated field expression:

展开 | 选择 | 换行 | 行号

推荐答案

您的想法：
是或 -1 或为真。

@Mihail


但是当我尝试编写代码时，它给出了一个错误：


"这个表达式键入不正确，或者它太复杂而无法评估。例如，数字表达式可能包含太多复杂元素。尝试简化expresion变量的表达式部分。


我怎样才能获得计算字段的变量？当我尝试[在]时，它只会提示我输入一个内部参数。 :(但该字段是一个计算字段。


这里是我的SQL代码，以便更好地理解：

@Mihail
But when I try to write the code, it gives me an error of:

"This expression is typed incorrectly, or its too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression parts of the expresion variables."

How could I get the variable of my calculated field? when I try [Within], it only prompts me to input a within parameter. :( but that field is a calculated field.

Here''s my SQL code for better understanding:

展开 | 选择 | Wrap | 行号

对不起，我对SQL的了解几乎为空。

我通过在设计视图中创建查询，然后切换到SQL视图来处理它，然后将该字符串复制到VBA中。

当然我尽量避免这种情况（在VBA中使用SQL）。

看看这里了解原因：
http://bytes.com/topic/access/answer...ry#post3702136

Sorry by my knowledge in SQL is almost null.
I handle that by creating a query in design view, then switching to SQL view, then COPY that string into VBA.
Of course I try to avoid that (using SQL in VBA) as more as I can.
Take a look here to understand why:
http://bytes.com/topic/access/answer...ry#post3702136

这篇关于查询中计算字段的标准的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！