What a strange error!
You execute an SQL statement with the usual OpenRecordset() function in MS-Access. So as usual, you put one parameter to the function, the SQL order.
You have written 100 of those before and had no problems.
Today, the last one you wrote says:
Too few parameters. Expected 1.
You look at this latest statement and your older statements and you just plainly don't get it. There is one parameter, it is the SQL string and it looks just fine.
So? What's wrong?
Simple! The error actually means a field name in the SQL statement is wrong. Yeah! That's how you need