Choosing the field

[Bruce]

In a report, I want to be able to see if there is a value
in the Personal Fax field. If there is, I want to use it;
if there is not, I want to use the Main Fax field. I have
tried =IIf(IsNull([Personal Fax]),[Main Fax],[Personal
Fax]. I have also tried a variant with Not IsNull. If
instead of the [Main Fax] field I use "text" it works, but
it does not work with the field name. What am I doing
wrong?

 

[Rick Brandt]

In a report, I want to be able to see if there is a value
in the Personal Fax field. If there is, I want to use it;
if there is not, I want to use the Main Fax field. I have
tried =IIf(IsNull([Personal Fax]),[Main Fax],[Personal
Fax]. I have also tried a variant with Not IsNull. If
instead of the [Main Fax] field I use "text" it works, but
it does not work with the field name. What am I doing
wrong?

The name of the control isn't "Main Fax" by any chance is it? Controls
based on expressions cannot be named the same as any field used within that
expression.

 

[Bruce]

That was it. So simple now that I know. Thanks so much.

-----Original Message-----

In a report, I want to be able to see if there is a value
in the Personal Fax field. If there is, I want to use it;
if there is not, I want to use the Main Fax field. I have
tried =IIf(IsNull([Personal Fax]),[Main Fax],[Personal
Fax]. I have also tried a variant with Not IsNull. If
instead of the [Main Fax] field I use "text" it works, but
it does not work with the field name. What am I doing
wrong?

The name of the control isn't "Main Fax" by any chance is it? Controls
based on expressions cannot be named the same as any field used within that
expression.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.