New Field Name on Newly created query

[inan25]

I am fairly new in access and I wanted to make a query with a new field name based on the newly created query. Can anybody help me accomplish this? Thanks!

Original Data

Data
1
2
3


4
1
2
3
4
2
3
1
4
3


Sorted Query

Data
1
1
1
2
2
2
3
3
3
3
4
4
4


Wanted Result (Note: the dots are just to separate the two fields)

NewFieldName Data
One..................1
One..................1
One..................1
Two..................2
Two..................2
Two..................2
Three................3
Three................3
Three................3
Three................3
Four..................4
Four..................4
Four..................4

[tinytree]

You want to translate it to english (new line), I have give u an advice ,you creat a new talbe include two fields. on in num and the other is eng. contents list down:
num eng
1 one
2 two
3 three
4 four
and so on.......
now you can join the table to get the result that you wanted

[inan25]

Thanks for the reply! But I do not want it to be translated to english. I just want the data to have a new entry in a separate field with reference to the original data.

Original Data

Data
1
2
3
4
1
2
3
4
2
3
1
4
3


Sorted Query

Data
1
1
1
2
2
2
3
3
3
3
4
4
4


Wanted Result (Note: the dots are just to separate the two fields)

NewFieldName Data
Apples..................1
Apples..................1
Apples..................1
Grapes..................2
Grapes..................2
Grapes..................2
Bananas................3
Bananas................3
Bananas................3
Bananas................3
Oranges................4
Oranges................4
Oranges................4

[tinytree]

Try it :
select "c"& data as newfieldname,data from yourtable ordery by data .
Is this it? I am not sure beacause my english is very poor.