Hi, I have done this million times with no problem and this simple statement gives me problem "Too few parameters. Expected 2:. What am I missing here?
Dim sSQL As String
Dim db As Database
Dim rs As Recordset
sSQL = "SELECT EmailsPeopleM.JobID, EmailsPeopleM.CustName, EmailsPeopleM.[First Name], EmailsPeopleM.[Last Name], EmailsQtyUnion.PartNumber, EmailsQtyUnion.Description, EmailsQtyUnion.Rev, EmailsQtyUnion.InitialQty, EmailsQtyUnion.StateName, EmailsQtyUnion.RealQty, EmailsPeopleM.email, EmailsPeopleM.CustID FROM EmailsPeopleM LEFT JOIN EmailsQtyUnion ON EmailsPeopleM.JobID = EmailsQtyUnion.JobID;"
Set db = CurrentDb
Set rs = db.OpenRecordset(sSQL, dbOpenDynaset, dbSeeChanges)
Query works fine by itself... Please guide me here.
Dim sSQL As String
Dim db As Database
Dim rs As Recordset
sSQL = "SELECT EmailsPeopleM.JobID, EmailsPeopleM.CustName, EmailsPeopleM.[First Name], EmailsPeopleM.[Last Name], EmailsQtyUnion.PartNumber, EmailsQtyUnion.Description, EmailsQtyUnion.Rev, EmailsQtyUnion.InitialQty, EmailsQtyUnion.StateName, EmailsQtyUnion.RealQty, EmailsPeopleM.email, EmailsPeopleM.CustID FROM EmailsPeopleM LEFT JOIN EmailsQtyUnion ON EmailsPeopleM.JobID = EmailsQtyUnion.JobID;"
Set db = CurrentDb
Set rs = db.OpenRecordset(sSQL, dbOpenDynaset, dbSeeChanges)
Query works fine by itself... Please guide me here.