Help! is there a way to convert a number to a text field?

[RayBec]

I have a field that was defined as a long integer that I neeed to convert to a text field. Can anyone help?

 

[luceze]

In the design view of your table change the data type to text.

 

[RayBec]

Thanks for the response. Is there a way to do the conversion via a sql command(the opposite of the 'val') command?

 

[hsitz]

str(numbervariable) will return a variant of string type for the value of numbervariable. -- Herb

 

[RayBec]

I'm using access 2000...when I do the command 'select str(numvar) from table'. I get the message 'Undefined function 'STR' in function. Help!