Adding Text Label if Control Is Not Blank

[dhoward via AccessMonster.com]

This was partially addressed in a posting from January 2005 but I only have
the most basic grasp of Access and can't figure out how to create the command.
I am creating a report.

I have a control called reports to. If there is data in the control, I want
to print a label Reports To:

Here's how I guessed how to do it but I'm getting an error message indicating
I have the wrong number of arguments.

=IIf(NotIsNull([reportsto]) & "Reports To: " & [reportsto])

 

[Marshall Barton]

This was partially addressed in a posting from January 2005 but I only have
the most basic grasp of Access and can't figure out how to create the command.
I am creating a report.

I have a control called reports to. If there is data in the control, I want
to print a label Reports To:

Here's how I guessed how to do it but I'm getting an error message indicating
I have the wrong number of arguments.

=IIf(NotIsNull([reportsto]) & "Reports To: " & [reportsto])

=IIf(Not IsNull([reportsto]),"Reports To: " & [reportsto])

Note that you can get the same effect from:
="Reports To: " + [reportsto]