How to Pad Values in Microsoft Access

[@SAMYTAHER]

Great, thank you very much, keep it up

[@seanmackenziedataengineering]

Thx!

[@simonmaersk]

Hi Sean. Great tip! For left padding, I simply use the Format function. So "Format("123", "00000")" returns "00123". However, I have never needed right padding, so the method you showed will definitely come in handy if I ever need it.

[@seanmackenziedataengineering]

Great tip! That's a good one. I think lots of people also just concatenate the string "00000" or "XXXXX" or whatever, then get Right/Left.

[@tuffley2175]

📝 Is it possible to pad with random numbers and unique!!!! ( when I ask for a rise I get left padding increase😢)

[@seanmackenziedataengineering]

I see! That's a great idea - nice idea to use random numbers but that would be another video (cool one). We would look into a random function for that 🛠

[@tuffley2175]

Good on you (Attitude of a MVP)🎬