1 123 Feb 12, 2004 #1 Thank you Is there any function can I use in query grid to change the Numeric field to text Thank you
Thank you Is there any function can I use in query grid to change the Numeric field to text Thank you
F fredg Feb 12, 2004 #2 Thank you Is there any function can I use in query grid to change the Numeric field to text Thank you Click to expand... cStr([NumberField])
Thank you Is there any function can I use in query grid to change the Numeric field to text Thank you Click to expand... cStr([NumberField])
G Graham R Seach Feb 12, 2004 #3 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
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
