Hello all,

I have tried to use macro to set up SQL statment to use macro

for i = 1 to 10

SQL_Text = "INSERT INTO testtable( empno,Solde ) SELECT empno,solde&i from mytable"

next for

always not worked on solde&i variable

TIA for any help.