Help with IIF expression

[mrwhitehat]

I am using the following expression, but it returns an error. Could you guys tell me what I am doing wrong?


"Ministries Ministry" is a text field.

=IIf(IsNull([Ministries Ministry]),"No Ministries on Record",[Ministries Ministry])

Thanks!

[mrwhitehat]

Okay, I figured out the answer to my own question. Sorry!

[June7]

Expression looks okay to me but Nz is simpler.

=Nz([Ministries Ministry], "No Ministries on Record")

[mrwhitehat]

Worked great! Thank you June7.
Any ideas on my other question in this forum?

[June7]

Yes, I will try to answer it later tonight if, no one else has, when I can look at my db. I have a similar situation and need to review how I handled it.

[mrwhitehat]

Actually, after double checking the data, the NZ did not work. It goes to the null text regardless of the content of the field. Any thoughts? Thank you!

[mrwhitehat]

Okay, I had the two arguments reversed. Now it returns a "Size!" Error.

[June7]

Possibly the field actually has an empty string, not Null. I don't allow empty strings in tables. Is that a native field in table or result of a calculation that returns empty string?

Try:

=IIf([Ministries Ministry]="", "No Ministries on Record", [Ministries Ministry])

Rather odd field name, seems redundant.

EDIT: Did not see the post about Size! error. Don't know why that is happening.

[mrwhitehat]

Now it says "#Type!"
It is imported data. Is returns no value when viewed, so I am not sure if it is NULL or just blank.

[June7]

Don't understand Size! error.

One of those expressions should work.

What is the field type? Do you want to provide db for analysis? Follow instructions at bottom of my post.