I am getting an "[ODBC Microsoft Access Driver] Too Few Parameters. Expected 2" error. I'm trying to import an Access query result table into Excel. I have the connection setup correctly as I've used it before. I do, however, have a date range setup in a Form that the query is reading off of, which I'm thinking might be part of the problem. Here is the SQL code in the query:

SELECT [tbl_Daily_Lock_Status_Report]![loan officer_first name] & " " & [tbl_Daily_Lock_Status_Report]![Loan Officer_Last Name] AS [Loan Officer], tbl_Loan_Officer_State.State, tbl_Daily_Lock_Status_Report.Loan_Number, tbl_Daily_Lock_Status_Report.Program, tbl_Program_Types.[Mkt Type], tbl_Program_Types.Type, tbl_Daily_Lock_Status_Report.Rate, tbl_Daily_Lock_Status_Report.Loan_Amount, tbl_Daily_Lock_Status_Report.Lock_Date, tbl_Daily_Lock_Status_Report.[Lock_Request Date], tbl_Daily_Lock_Status_Report.Close_Date, tbl_Daily_Lock_Status_Report.Funded, tbl_Daily_Lock_Status_Report.Lock_Expire, tbl_Daily_Lock_Status_Report.[Trade_Settlement Date], tbl_Daily_Lock_Status_Report.Purpose
FROM (tbl_Daily_Lock_Status_Report LEFT JOIN tbl_Program_Types ON tbl_Daily_Lock_Status_Report.Program = tbl_Program_Types.Program) INNER JOIN tbl_Loan_Officer_State ON tbl_Daily_Lock_Status_Report.[Loan Officer_Last Name] = tbl_Loan_Officer_State.[Loan Officer_Last Name]
WHERE (((tbl_Daily_Lock_Status_Report.[Lock_Request Date]) Between [Forms]![Date Range Set]![QuarterlyDateFrom] And [Forms]![Date Range Set]![QuarterlyDateTo]))
ORDER BY [tbl_Daily_Lock_Status_Report]![loan officer_first name] & " " & [tbl_Daily_Lock_Status_Report]![Loan Officer_Last Name];


Also, when I run the query in Access, it works perfect. It's just when I'm trying to bring it into Excel that I get the parameter error.