Query not working ( Inserting table based on value from a query)

[Vandy]

Hi,
I am trying to insert a table (tabtest) based on the value(accountno)
from the query (qryemployee).
This is the query I have,

strInputFileName = EmployeeName
strSQLtemp = "select accountno from qryEmployee"
strSql = "Insert into tabtest (AccountNo,Name) values (" & accountno &
",""" & strInputFileName & """)"
strSql = strSql & "where accountno in ( """ & strSQLtemp & """ );"

But I am getting error as the semicolon missing at the end of SQL
statement.

I have doubt on the field accountno. Is that correct?

Could you please help me to resolve this?

Thanks in advance.

 

[Vandy]

Hi

I figured it out. The query is working fine.

Thanks