I'm working in Visual Basic 6 with MS Access and trying to do an INNER JOIN on 3 tables and get a "too few parameters. Expect 1." error.
The SQL string is...
SELECT Qualifications.*, Roster.*, Arms.* FROM (Qualifications INNER JOIN Roster ON Qualifications.AgentID = Roster.ID) INNER JOIN Arms ON Qualifications.ArmID = Arms.ID WHERE (Qualifications.License = '050719100518') AND ( QualificationCourses.ID = 4 ) AND (Roster.Active = True) AND (Qualifications.QualDate BETWEEN #10/31/2000# AND #10/31/2011#) ORDER BY Qualifications.Course ASC, Roster.LName ASC, Roster.FName ASC, Qualifications.QualDate ASC