Mixed Strings & Numbers

[Eugene]

How would it be possible for me to have this code in one string.

"INSERT INTO Repairorder"+" (wrono, techno, clientname, clientno, nor1)"+" VALUES "+value( "Counter" )+"', "+"'"+Edittext$( "Tech No" )+"', "+"'"+Edittext$( "Client Name" )+"', "+"'"+Edittext$( "Client no" )+"', "+"'"+Edittext$( "Nature Of Repair" )+"');"

I want to use a counter value with other strings

[Eugene]

or add the value of a counter object to a text edit box ?

[DavidN]

To convert a number to a string, enclose it in Str$( ) - this should go around the value("Counter") here.

[Eugene]

COOL THANKS ALOT :0