Iff statement

[Guest]

I am trying to have a field for a label to show a generic title like office
manager if there is no name in the field and I cannot get the name to show
up. I am using
=IIf([field name]<> "a","Office Manager",[Field name])
With this I am getting the "office manager but not the field name.
Any help appreciated.

Thanks
Joe

 

[Al Camp]

=IFF(IsNull([FieldName]),"Office Manager",[FieldName].[Name])
hth
Al Camp

 

[Ken Snell [MVP]]

Perhaps this:

=IIf(Len([field name] & "")=0,"Office Manager",[Field name])

 

[Guest]

Thanks

 

[Guest]

Thanks, your response is much appreciated.

Joe