How can I add just a letter to a string?

Question

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 Answer

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.