Hi,
I have little experience with access databases but i have been wondering about the issue. I have a database with specific column that contain 3 values: High, Medium, Low(in my native language).
So far i have a query counting the number of appearances each one of them. I would like the same query but with exception that it will change the text in my native language into English ones(High, Medium, Low).
Is there any way I could do it?
Thanks in advance!
misi06
EDIT: To be clear I want the 3 values ot be changed only in query, not in the database.