Join two strings together

[thuynguyen]

Dear everyone,

I would like to join a prefix and a number which are separated by a "-" and do not know why it could not work for me. Can you please tell me why this code doesn't work:

=IIf([Prefix] Is Null,"",Trim$([prefix])) & “-“ & Right$(Str$([Voucher No]+10000),4) & IIf([Suffix] Is Null,"",Trim$([Suffix]))

It is in a report and always as me to Enter Parameter "

Otherwise the following works but without a "-"

=IIf([Prefix] Is Null,"",Trim$([prefix])) & Right$(Str$([Voucher No]+10000),4) & IIf([Suffix] Is Null,"",Trim$([Suffix]))

Cheers.

[FishVal]

Dear everyone,

I would like to join a prefix and a number which are separated by a "-" and do not know why it could not work for me. Can you please tell me why this code doesn't work:

=IIf([Prefix] Is Null,"",Trim$([prefix])) & “-“ & Right$(Str$([Voucher No]+10000),4) & IIf([Suffix] Is Null,"",Trim$([Suffix]))

It is in a report and always as me to Enter Parameter "

Otherwise the following works but without a "-"

=IIf([Prefix] Is Null,"",Trim$([prefix])) & Right$(Str$([Voucher No]+10000),4) & IIf([Suffix] Is Null,"",Trim$([Suffix]))

Cheers.

Hi, there.

Just a thought. Try to use IsNull() function instead of object comparisson operator "Is".
And BTW the expression could be simplified.

1. Concatenation operator "&" unlike math and logic operators doesn't work according to tristate logic.
e.g.
? "qwerty" + Null
Null
? "qwerty" & Null
qwerty

So check for Null value is not needed.

2. Expression

Right$(Str$([Voucher No]+10000),4)
 

will return always the same as

Right$(Str$([Voucher No]),4)
 

And, not concerning the problem, get reed of all this "$". This exists for backward compatability only and is supposed to be ceased in future.