这很奇怪！ [英] This is odd!

问题描述

我有一个查询，其中包含此表达式

FirstName：IIf（IsNull（[Preferred Name]），Member，[Preferred Name]）


奇怪的是，当我运行查询时，首选

名称为空白的某些记录显示会员但其他人不会。我在记录中看不到任何不同的

，并且无法理解为什么该表达式适用于某些

记录而不是其他记录。任何人都可以帮忙吗？


TIA

Tony Williams

解决方案

我的初始肠道反应是一些字符串是。而其他人则是

Null。


我会尝试使用IIf（nz（（[Preferred Name]），""）="" ;，会员，[首选

名称]）


让我知道你是怎么过的。

- -

如果（a）这封电子邮件

包含病毒，请立即通知我们（通过电话或回复邮件）

（b）你不是预定的收件人

（c）您认为此电子邮件是垃圾邮件。

我们已尽最大努力确保

none以上是适用的。谢谢

由AVG反病毒系统检查（ http：// www .grisoft.com）。

版本：6.0.698 /病毒库：455 - 发布日期：02/06/2004

< blockquote>谢谢我收到语法错误消息输入了一个没有

运算符的操作数有什么想法吗？

谢谢

Tony

" WindAndWaves" <交流**** @ ngaru.com>在消息中写道

news：cy ******************** @ news.xtra.co.nz ...

我最初的直觉反应是某些字符串是"而其他人
是空的。

我会尝试使用IIf（nz（（[Preferred Name]），""）=""，" Member"，[首选
姓名]）

让我知道你是怎么过的。

---
请立即告诉我们（通过电话或回复电子邮件） ）如果（a）此
电子邮件包含病毒
（b）您不是预定的收件人
（c）您认为此电子邮件是垃圾邮件。
我们已经完成了最大限度地确保
以上都不适用。谢谢
由AVG反病毒系统检查（ http://www.grisoft.com ）。
版本：6.0.698 /病毒数据库：455 - 发布日期：02/06/2004

< blockquote>

让我们再试一次：


基本是：[首选名字]

然后试试这个：NZ（[首选名称]，"

然后：iif（len（[Preferred Name]）> 0，member，[Preferred Name]

next：iif（NZ（[Preferred Name]，"）=""，member，[Preferred Name]）


如果慢慢制作语法更复杂，你可以找到它的位置

错误...经常是非常愚蠢的东西。


让我知道你怎么走。


Ciao Chow


Nicolaas


" Tony Williams"< [e-mail]>写道：消息

news：c9 ********** @ sparta.btinternet.com ...

谢谢我收到语法错误消息输入没有
运算符的操作数有什么想法吗？
谢谢
Tony
WindAndWaves <交流**** @ ngaru.com>在消息中写道
新闻：cy ******************** @ news.xtra.co.nz ...

我的最初的肠道反应是一些字符串是。而其他人

是

Null。

我会尝试使用IIf（nz（（[Preferred Name]），" =
""，" Member"，[Preferred Name]）

让我知道你是怎么过的。

---
如果（a）此

电子邮件

包含病毒，请立即告知我们（通过电话或回复电子邮件）
（b）您不是预期的收件人
（c）您认为此电子邮件是垃圾邮件。
我们已尽最大努力确保上述任何一项都不适用。谢谢
由AVG反病毒系统检查（ http://www.grisoft.com ）。
版本：6.0.698 /病毒数据库：455 - 发布日期：02/06/2004

---

如果（a）此邮件

包含病毒，请立即通知我们（通过电话或回复邮件）

（b）您不是预定的收件人

（c）您认为此电子邮件是垃圾邮件。

我们已尽最大努力确保

以上都不适用。谢谢

由AVG反病毒系统检查（ http：// www .grisoft.com）。

版本：6.0.698 /病毒库：455 - 发布日期：02/06/2004

I have a query which includes this expression
FirstName: IIf(IsNull([Preferred Name]),"Member",[Preferred Name])

What is odd is that when I run the query some records where the Preferred
name is blank show Member but others do not. I can''t see anything different
in the records and cannot understand why the expression works for some
records and not others. Can anyone help?

TIA
Tony Williams

解决方案

My initial gut reaction is that some of the strings are "" while others are
Null.

I would try to use IIf(nz(([Preferred Name]), "") = "","Member",[Preferred
Name])

Let me know how you get on.
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.698 / Virus Database: 455 - Release Date: 02/06/2004

Thanks I get an syntax error message "entered an operand without an
operator" Any ideas?
Thanks
Tony
"WindAndWaves" <ac****@ngaru.com> wrote in message
news:cy********************@news.xtra.co.nz...

My initial gut reaction is that some of the strings are "" while others are Null.

I would try to use IIf(nz(([Preferred Name]), "") = "","Member",[Preferred
Name])

Let me know how you get on.
---
Please immediately let us know (by phone or return email) if (a) this email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.698 / Virus Database: 455 - Release Date: 02/06/2004

Lets try it again:

the basic is: [Preferred Name]
then try this: NZ([Preferred Name], "")
then this: iif(len([Preferred Name])>0, "member", [Preferred Name]
next: iif(NZ([Preferred Name], "")="", "member", [Preferred Name])

if you slowly make the syntax more complex, you can find out where it goes
wrong... Often something very stupid.

Let me know how you go.

Ciao Chow

Nicolaas

"Tony Williams" <[e-mail]> wrote in message
news:c9**********@sparta.btinternet.com...

Thanks I get an syntax error message "entered an operand without an
operator" Any ideas?
Thanks
Tony
"WindAndWaves" <ac****@ngaru.com> wrote in message
news:cy********************@news.xtra.co.nz...

My initial gut reaction is that some of the strings are "" while others

are

Null.

I would try to use IIf(nz(([Preferred Name]), "") = "","Member",[Preferred Name])

Let me know how you get on.
---
Please immediately let us know (by phone or return email) if (a) this

email

contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.698 / Virus Database: 455 - Release Date: 02/06/2004

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.698 / Virus Database: 455 - Release Date: 02/06/2004

这篇关于这很奇怪！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！