concatenation

[iainrkemp14]

I am trying to write an update query that will update column B with 5 zeros and the contents of column A.

For example:

Column A = 12345
Column B = 0000012345

How can I do this? I have tried "00000"&[Column A] but that doesn't seem to work.

Cheers,

- Iain

 

[Blorf]

Try this:

Right("0000000000" & trim (Val ([Column A])), 10)

This will result in having up to 10 trailing zeros, no matter how big your number is. So if column a has 1, it will return 0000000001. If it is 10, it will return 0000000010, with out having to do any iif statements.

Hope this helps.

Thank you,
Charles Smith