IIF syntax?

[flect]

I currently have a text box on my report that is operating correctly:

=IIf([stampTAB]=True,"*Tab+*","")

I have added another field to my table - [numberoftabs]

What I need to do is print the value of [numberoftabs] before "*Tab+*" in my IIF statement.

at the moment it's printing

"[numberoftabs] *Tab+*"

I've tried a few things but I just can't seem to get the syntax correct.

=IIf([stampTAB]=True,"[numberoftabs] *Tab+*",")

=IIf([stampTAB]=True,"([numberoftabs])" "*Tab+*",")

Any ideas? Your help is greatly appreciated

 

[boblarson]

=IIf([stampTAB]=True,[numberoftabs][color=red] &[/color] "*Tab+*","")

 

[flect]

Perfect! Thanks a lot!

 

[boblarson]