Nz, IIF

S

Stephanie

I swear I've lost my brain!
I have two fields- one for Member Name and one for Company. I've stripped it
down so there is either a MemberName or a CoName.

I want to "merge" this into one field- meaning list either the Member Name
or the Company into the field.
I tried nz([MemberName], [COName]) which only brought back CoName.
I tried IIf([COName] Is Null,[MemberName],[COName]) which only brought back
CoName

What am I not doing?
 
S

Stephanie

Okay. I tried this with success:
IIf(Len(Trim([CoName]))=0,[MemberName],[CoName])
 
Y

Yaacov Klapisch

If COName is text then the syntax should be IIf([COName] =
"",[MemberName],[COName])

Stephanie said:
Okay. I tried this with success:
IIf(Len(Trim([CoName]))=0,[MemberName],[CoName])

Stephanie said:
I swear I've lost my brain!
I have two fields- one for Member Name and one for Company. I've stripped
it
down so there is either a MemberName or a CoName.

I want to "merge" this into one field- meaning list either the Member
Name
or the Company into the field.
I tried nz([MemberName], [COName]) which only brought back CoName.
I tried IIf([COName] Is Null,[MemberName],[COName]) which only brought
back
CoName

What am I not doing?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box that displays field from another table 1
populate fields in a form 2
How To Keep DropDown From Printing? 2
IIf Nz 4
Placing Core Company Identification DAta in All Reports 2
Nz or Iif 8
Overflow from Calculation - How do I do Calculation? 10
Nz function 6

Top