Converting Number To Text

[gatarossi]

Dear all,

I'm trying to do a INSERT TO consult... and in my table 1 I have this
field 200702 - the format in text (it means year 2007 month february).
Now I need to sum for example 1 month and include it in the same
table... But now this is a number field... How can I transform it in
text again?

Thanks a lot!!!

André.

 

[Guest]

use the Cstr function. So try Cstr([field]) where field is your fieldname.

hth