Insured Name (1 Viewer)

[specialk1116]

I have a report that I am trying to make it list an insuredName, and if I don't have insured name it would input a insuredCompany name.

This is what I have. What is wrong? HELP
=IIf(IsNull([insuredname]),[insuredCompany] & " " & [insuredName])

 

[pr2-eugin]

Hello specialk1116, Welcome to AWF..

Your description is quiet vague. Could you maybe use an example to explain what you want to do?

 

[pbaldy]

Moved to a more appropriate forum.

 

[specialk1116]

My I have my report right now showing the below:
Insured Name:
Insured Company:

(There are 2 seperate fields in my report)

The majority of the time I have an Insured Name. There is a few circumstances where I don't have an insured name, I have a insured company name. I would like to just have one field, where if I have an insured name it would put it in there, or if I have an insured company it would put it in there. This is what I was using.

=IIf(IsNull([insuredname]),[insuredCompany] & " " & [insuredName])

Is this possible. I hope this describes what I want to do better.

Sorry Im new. If I posted this in the wrong area Sorry.

 

[pbaldy]

Try

=IIf(IsNull([insuredname]),[insuredCompany], [insuredName])

or simply =Nz([insuredname],[insuredCompany])

 

[specialk1116]

pbaldy - thank you so much!!!!! It Worked.

 

[pbaldy]

No problem, and welcome to the site! You had this in the "Introduce Yourself" forum, which is supposed to be used for introductions, so I moved it here.