Numeric to text in query Grid

[123]

Thank you

Is there any function can I use in query grid to change the Numeric field to
text

Thank you

 

[fredg]

Thank you

Is there any function can I use in query grid to change the Numeric field to
text

Thank you

cStr([NumberField])

 

[Graham R Seach]

If by "text" you mean "words", then the following link might help:
http://www.pacificdb.com.au/MVP/Code/Num2Text.htm

Then you can use it in a query like so:
SELECT Num2Text(MyNum, 1) As NumWords FROM tblMyTable

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia

 

[123]

Thank you very much
Cstr work with my query
Thank you