Search results

Thanks for your advice / suggestion. The code worked 100%. Fantastic

Thanks am getting stuck into brushing up on the module bit now and will give you feedback. I appreciate your help

Wow, that was quick. It gives me hope, this can be done! I am a bit slow digesting your post. Can this be done in an Access 2007 expression?

oops. The data changed data should look like this: HeadOffice.Financial Accounts Group.Fleet Accounts Div.Users

I have a AD data in a table. The data looks like this: Users.Fleet Accounts Div.Financial Accounts Group.HeadOffice the period (.) separates the Organsation units It needs to be changed to look like this: Fleet Accounts Div.Financial Accounts Group.HeadOffice.Users. Is there way any to to...

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?

Hmmm. Have a look in the Expression builder

Cape Town, South Africa. A windy day, 24c