Help Adding Underscore At End of Number

[markel580]

Hi, I have a set of account numbers that I need to add an underscore to the end of, so 1234 to show as 1234_ I recall doing this a while ago but cannot remember how, I know it ended & "_" as .... but cannot remember? I've look online, but cannot find the solution? Any suggestions please?

[mikaelsc]

"field" & '_' as "NewFieldName"

single quotes for text values... double quotes for fieldnames 

[MarcoWedel]

Num(AccountNo,'0_')

[MarcoWedel]

also possible:

Dual(AccountNo&'_',AccountNo)