Query arabic text

[bilalo]

I have the following query: Select ItemName & "/" & Price1 & "/" & Price2 from items

When the item name is english, I get the result that I want, something like this : Pizza/1000/2000


But when the item name is arabic, the result becomes from right to left like this: 2000/1000/بيتزا
How can I force the second result to show the arabic item name to the left of the prices like the first result?

[Micron]

I don't know if a query expression can evaluate if Arabic text is in the range of those Unicode characters (e.g. by using IIF and Asc or AscW functions) but I think code can. So your query could make use of the return value of a called function. If that function detects characters in the portion of the string separated from the rest (with / I guess) then it could be reversed by the function.

EDIT - if you want to post a compacted and zipped copy of your db with enough value to test I expect I or someone could find the time to figure that part out, but I'm not about to build a table with sample data to test my theory. If you need help on how to upload a db here, see 'How to attach files' and the top of this page.

[Welshgasman]

Seem Access is clever enough to know that Arabic goes from right to left?
So identify how which is normal or Arabic and adjust accordi gly