Inserting a variable

[Matt]

Ignore post, have solved problem

.CommandText = Array("SELECT * FROM ""TESTLIB"".""TESTA0" & i & """")




I'm having a problem inserting an integer variable 'i'. I would like to replace the '1' at the end of 'TESTA01' with the variable but not sure where to insert it.

.CommandText = Array("SELECT * FROM ""TESTLIB"".""TESTA01""")

have tried this, problem may not be related to variable.

.CommandText = Array("SELECT * FROM ""PEDLIB"".""PECA0"" & i & """)

Any help would be appreciated.

thanks Matt
This message was edited by Matt on 2002-10-16 05:32
This message was edited by Matt on 2002-10-16 06:15