Reverse Text

[Vivienne]

Hi, I am working on Access 2007. I have a field with with Active Directory data in it. I need to reverse this text string Users; Financial Payments Div; Financial Accounts Group; HeadOffice to HeadOffice; Financial Accounts Group; Financial Payments Div; Users. Is their any expression to do this?

 

[Timrock]

Hmmm. Have a look in the Expression builder

 

[Timrock]

I think you are looking at Reversing the words.

What is now

Users; Financial Payments Div; Financial Accounts Group; HeadOffice

you want to be

HeadOffice; Financial Accounts Group; Financial Payments Div; Users

Can you confirm please?

 

[Vivienne]

Thank you