convert numeric to text

[B]

Anyone know how to convert a numeric value to text?

 

[Douglas J. Steele]

Depends what you mean. Do you want 1 to be "1", or 1 to be "one"?

For the first, you can use the Format function or the CStr function.

For the second, take a look at
http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"

 

[Guest]

What I mean is this. I have two tables, I am running a
Unmatched query against two columns, one in each. When I
do this, I get a type mismatch error. Column1 in table
one is set to Number. Column2 on table 2 is varchar. I
would like to make the datatypes the same so I don't get
the error.
Thanks!