MarkRobinson
Programmer
I've taken the SQL code from a query that works and pasted it into the openrecordset arguement. When I run it, I get
Too Few Parameters. Expected 1
Does anyone know why this might be hapening?
Set rs1 = db.openrecordset("SELECT [Statement Query].Transactions.ID AS mmid, [Statement Query].PRINT AS Mprint, [Statement Query].email AS memail, [Statement Query].sendemail FROM [Statement Query] GROUP BY [Statement Query].Transactions.ID, [Statement Query].PRINT, [Statement Query].email, [Statement Query].sendemail HAVING ((([Statement Query].sendemail)=-1)) ORDER BY [Statement Query].Transactions.ID;")
This is a query based on another query (Called Statement Query)
Too Few Parameters. Expected 1
Does anyone know why this might be hapening?
Set rs1 = db.openrecordset("SELECT [Statement Query].Transactions.ID AS mmid, [Statement Query].PRINT AS Mprint, [Statement Query].email AS memail, [Statement Query].sendemail FROM [Statement Query] GROUP BY [Statement Query].Transactions.ID, [Statement Query].PRINT, [Statement Query].email, [Statement Query].sendemail HAVING ((([Statement Query].sendemail)=-1)) ORDER BY [Statement Query].Transactions.ID;")
This is a query based on another query (Called Statement Query)