Change number% format to text

[Alex]

I have a field in my table called [Score], that has a data type as number,
format: percent. I have an append query that appends records from that table
to another table where the [Score] field is a text data type (which cannot be
changed). I need to change the data type of the [Score] field to text before
I append the records to the table containing [Score] as text.

Is there an easy way to do this like: NewName: Format([OldName],????) or
do I have to do an update query?

Thanks

 

[Ofer]

Try
Cstr (FieldName)

 

[Alex]

perfect - thanks

Try
Cstr (FieldName)

I have a field in my table called [Score], that has a data type as number,
format: percent. I have an append query that appends records from that table
to another table where the [Score] field is a text data type (which cannot be
changed). I need to change the data type of the [Score] field to text before
I append the records to the table containing [Score] as text.

Is there an easy way to do this like: NewName: Format([OldName],????) or
do I have to do an update query?

Thanks