Combinding fields 2

[lashwarj]

I have a numeric autonumber field that well I guess its obvious it generates an autonumber. Then I have a type field that is linked to a code. I want the code to be followed by the autonumber (ex. Type = Radiator Code = RA autonumber = 007 Assigned_Num = RA007) assigned_Num is the field I want to store the value in, it is a text field. When trying to do this I get a data type error, so how would i make this so I can store the two together. I was using the =abbs(ALLTRIM(code) + abbs(ALLTRIM(autonumber))

 

[danceman]

textnumber = alltrim(str(realnumber))

str() function converts number to string, check the help file for formating options. Attitude is Everything

 

[furmious]

You have a character field (code) and a numeric field (autonumber). Try this;

assigned_num=allt(code)+allt(str(autonumber))

 

[lashwarj]

Thanks guys it woks great