Copy and add the data into the table

[ahmadbaseet]

Hello, I have problem. I want to copy the data from the table and add it to another table. This is simple, But the problem is that the I want to copy as well as add the data from variables into table. i.e.
strSQL2 = "INSERT INTO SubProj (Project, SubProject, Stundensatz ) SELECT SubProjectName, Kosten FROM Mustertabelle WHERE Check = -1 "

In SubProj, I want to add in Project field not from the other table but from the variable called pNumber. Can somebody help me.. Thanks in advance

[ahmadbaseet]

please help me. it is urgent

[kjworm]

Hello, I have problem. I want to copy the data from the table and add it to another table. This is simple, But the problem is that the I want to copy as well as add the data from variables into table. i.e.
strSQL2 = "INSERT INTO SubProj (Project, SubProject, Stundensatz ) SELECT SubProjectName, Kosten FROM Mustertabelle WHERE Check = -1 "

In SubProj, I want to add in Project field not from the other table but from the variable called pNumber. Can somebody help me.. Thanks in advance

Try:

strSQL2 = "INSERT INTO SubProj (Project, SubProject, Stundensatz ) SELECT "& pNumber &" , SubProjectName, Kosten FROM Mustertabelle WHERE Check = -1 "
 

This is for if your pNumber is calculated in the code
or

strSQL2 = "INSERT INTO SubProj (Project, SubProject, Stundensatz ) SELECT "& [pNumber] &" , SubProjectName, Kosten FROM Mustertabelle WHERE Check = -1 "
 

This is for if you pNumber is on your form or whatever.