非操作员不工作？ [英] Not-operator not working?

问题描述

在桌子外面，我正试图拉出场上的每一条记录

''姓氏''不是''约翰逊''。

为了做到这一点，我把下面的''条件'字段放在

查询窗口旁边：

不是约翰逊

然而结果表是空的。

有人知道它为什么不起作用吗？

谢谢，

john

Out of a table I''m trying to pull out every record in which the field
''Lastname'' is not ''Johnson''.
In order to do this I''ve put the following next to the ''criteria'' field in
the query-window:
Not "Johnson"
However the resulting table is empty.
Does someone know why it''s not working?
Thanks,
john

推荐答案

当条件中没有任何内容时，查询是否会提取记录

字段？
< br $>
Sarah Schreffler


john写道：

Does the query pull up records when there is nothing in the criteria
field?

Sarah Schreffler

john wrote:

表中我正在尝试拉出该领域的所有记录

''姓氏''不是''约翰逊''。

为了做到这一点，我已经把下面的内容放到了下面查询窗口中的标准字段

：

不是约翰逊

然而结果表是空的。

有人知道它为什么不起作用吗？

谢谢，

john

Out of a table I''m trying to pull out every record in which the field
''Lastname'' is not ''Johnson''.
In order to do this I''ve put the following next to the ''criteria'' field in
the query-window:
Not "Johnson"
However the resulting table is empty.
Does someone know why it''s not working?
Thanks,
john

查询没有给我任何记录，而有些记录的

空值为标准字段''姓氏''。

当我在查询中不使用not-criteria时，它会将表中的每条记录拉出来。
。 >
john


" Sarah Schreffler" < sa ************** @ gmail.comschreef在bericht

新闻：11 **************** ****@s13g2000cwa.googlegrou ps.com ...

The query doesn''t give me any records while there are some records with
empty values for the criteria field ''Lastname''.
When I don''t use the not-criteria in the query it pulls up every record in
the table.
john

"Sarah Schreffler" <sa**************@gmail.comschreef in bericht
news:11********************@s13g2000cwa.googlegrou ps.com...

如果条件中没有任何内容，查询是否会提取记录

field？


Sarah Schreffler


john写道：

Does the query pull up records when there is nothing in the criteria
field?

Sarah Schreffler

john wrote:

>在桌子外面，我正在试图取出每一个领域
''姓''不是''约翰逊'的记录。
为了做到这一点，我放了在查询窗口的标准字段旁边
：
不是约翰逊
但是生成的表格是空的。
是否有人知道为什么它不起作用吗？
谢谢，
john

>Out of a table I''m trying to pull out every record in which the field
''Lastname'' is not ''Johnson''.
In order to do this I''ve put the following next to the ''criteria'' field
in
the query-window:
Not "Johnson"
However the resulting table is empty.
Does someone know why it''s not working?
Thanks,
john

它''没有更多细节，很难说。你可以发布这个查询生成的s / b
吗？ （单击SQL视图而不是蓝色设计

三角形）。

可能的原因可能是您还有一些其他标准在

同一时间和组合排除所有记录，或者你做了内部

加入另一个没有匹配记录的表，或者至少没有

匹配记录那不叫约翰逊。

祝你好运

" john" < jo ** @ test.comwrote in message

news：Ls ******************** @ casema.nl ...

It''s hard to say without more details. Can you post the sql that is
generated by this query? (click on SQL view instead of the blue design
triangle).
Possible causes may be that you have some other criterion going on at the
same time and the combination excludes all records, or that you did an inner
join to another table in which there are no matching records, or at least no
matching records that aren''t called "johnson".
good luck
"john" <jo**@test.comwrote in message
news:Ls********************@casema.nl...

表格中我试图提取该字段的每条记录

''姓氏''不是'' Johnson''。

为了做到这一点，我把下面的''标准'字段放在

查询窗口中：

不是Johnson

但是结果表是空的。

有人知道它为什么不起作用吗？

谢谢，

john

Out of a table I''m trying to pull out every record in which the field
''Lastname'' is not ''Johnson''.
In order to do this I''ve put the following next to the ''criteria'' field in
the query-window:
Not "Johnson"
However the resulting table is empty.
Does someone know why it''s not working?
Thanks,
john

这篇关于非操作员不工作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！