Format number as text

J

JeffH

I'm attempting to append a number in one table to a text field in another.
Is there any way in which I can format the number in the query so I don't get
the mismatch error?
 
K

Ken Snell [MVP]

Check out the CStr function. It converts a numeric value to a string value.
 
Top