Hi!

As Glenn already pointed out, seems something worng with your query. Did you tried to run similar query in the Access? Try "select * from quotetype where qtclientid = 1 and qtQuoteKey = 12" or something like this. If it runs Ok, that, again, the names of variables used for parameters could be wrong or variables do not exists at the moment when SQLExec() function runs. You can track this and similar problems by putting "SET STEP ON" command before the SQLEXEC() function call, than see in locals or whatch window the value of the paramater variable and if it exists.

HTH.

>Vlad:
> Sorry to bother you again. I am getting an error on this command:
>m.client_id = "test"
>m.totQuote = 2
>sql_str = "select * from quotetype where qtclientid = ?m.client_id and qtQuoteKey = ?m.totQuote"
>
>the error I got: [1,1]1526[1,2]totQuotes [MICROSOFT][ODBC ACCESS DRIVER] TOO FEW PARAMETERS. EXPECTED 5.
>
>It works if I use signle criteria in the WHERE clause. What will be the syntax for this sql? This is my first using sqlexec(). Thanks
>sherry