Convert number to text

[Guest]

I need a simple method of linking a number field in a query to a text field
from a table (that I can't change). I know there is a Val function to
convert text to a number. Is there an equivalent function the other way -
number to text?

 

[John Vinson]

I need a simple method of linking a number field in a query to a text field
from a table (that I can't change). I know there is a Val function to
convert text to a number. Is there an equivalent function the other way -
number to text?

Format(fieldname, "formatstring") probably; or CStr(fieldname) if your
text field is in the standard format for numbers defined in your
database properties.

It's not quite clear what is in your text field. If it's "Two hundred
and thirty-three dollars and forty-two cents" it'll be a lot harder
than if it's "$233.42".

John W. Vinson[MVP]