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

Null。


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

名称]）


让我知道你是怎么过的。

- -

如果（a）这封电子邮件

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

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

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

我们已尽最大努力确保

none以上是适用的。谢谢

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

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

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

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

谢谢

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

让我们再试一次：


基本是：[首选名字]

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

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

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


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

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


让我知道你怎么走。


Ciao Chow


Nicolaas


" Tony Williams"< tw@tcp.invalid>写道：消息

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

谢谢我收到语法错误消息输入没有
运算符的操作数有什么想法吗？
谢谢
Tony
WindAndWaves &LT;交流**** @ ngaru.com&GT;在消息中写道
新闻：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" <tw@tcp.invalid> 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