Symptoms
Whenever you run a SQL statement you get a “Too Few Parameters, expected X.”
Cause
Most common cause is misspelling or missing fields in the SQL statement.
Resolution
Check the SQL statement. If necessary, copy and paste to an Access query and test in the query to get it to highlight which part of the SQL is treated as a parameter.