Error 3061 too few parameters strSQL statement 1

[vba317]

Hello,
I have tried to add an and statement to an existing query that works and I keep on getting this error. I have tried different approaches and nothing seems to work. Everthing looks apaced correctly. Any help is appreciated.
Tom
My debug statement reads like
INSERT INTO PROC_RptSrc_ExecSumm SELECT dbo_RptSrc_ExecSumm.* FROM dbo_RptSrc_ExecSumm WHERE qrptid = 2935 AND runrpt = 1;

 strSQL = "INSERT INTO PROC_" & (strSrcTable) & " " & _
                                "SELECT dbo_" & (strSrcTable) & ".* " & _
                                "FROM dbo_" & (strSrcTable) & " " & _
                                "WHERE qrptid = " & (liQID) & " AND runrpt = 1" & ";"
                                Debug.Print strSQL
                    CurrentDb.Execute strSQL

 

[Andrzejek]

When you run this:

SELECT dbo_RptSrc_ExecSumm.* FROM dbo_RptSrc_ExecSumm WHERE qrptid = 2935 AND runrpt = 1

do you get (1)the same number of Fields, (2) in the same order (3) with the same declaration as when you run this:

SELECT * FROM PROC_RptSrc_ExecSumm

Have fun.

---- Andy

 

[vba317]

Thank you Andy I am looking at the wrong table.

 

[Andrzejek]

Can't help you there....

Have fun.

---- Andy