Iif statements

[nicwnacw]

I have a small database with letters as reports, sometimes I have a titke for a person but not always I want an Iif statement or IsNull so that if there is no title I can address the customer as Dear Sir/Madam. I have tried many variations and none seem to work can anyone help?


PLEASE

 

[RichO]

So for instance if John Smith does not have a "Mr" title specified, you want to address him by Sir/Madam as opposed to John Smith?

="Dear " & IIf(Nz([MyTitleField])="", "Sir/Madam", [MyTitleField] & " " & [MyNameField])