[MSAccessProfessionals] indent string to the right by space characters

Hi

 

I would like to achieve the following!

Is to move the string value to the right X number of spaces to right based upon a user input criteria.

 

Is there a function or SQL I could use to achieve the following without a case format, as that would be to limiting.

 

"1"                  (being level 0)

  "1.1"    (being Level 1)

     "1.1.1"      (being level 2)

 

Thanks

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116054) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_