troubleshooting Question

How do I pad spaces to a SELECT field in MS Access?

Avatar of bemara57
bemara57 asked on
Microsoft Access
4 Comments1 Solution5393 ViewsLast Modified:
How do I pad left to a field I select so it is always 10 characters long (padded with spaces. So this:

2834
02149803
203985
234

Would become this in my SELECT statment:
      2834 (padded 6 spaces to the left of the number)
  02149803 (padded 2 spaces to the left of the number)
    203985 (padded 4 spaces to the left of the number)
       234 (padded 7 spaces to the left of the number)

I'm looking for something in MS Access where I can do something like SELECT PAD(nbr," ") FROM table. Anything like this exist?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros