How can I add just a letter to a string?

[hellyars]

I have an account number, but I need to append a single letter 'A' to it.   I tried [AccountNumber]+'A'.  But, that did not work.  I tried changed the Account Number field to be  a string and that also did not work.  This has to be easy?  So, what am I failing to do?

[jdunkerley79 · Accepted solution]

If it is a number you are starting with then a formula of:

ToString([AcoountNumber]) + 'A'

should do what you need.

You will need to store it in a new string field with enough length for the concatenated string.

[hellyars]

ToString([AcoountNumber]) + 'A' works, but only if I set [AccountNumber] to a V_String and not a Double.    That works for me.