Memory variable in SQL Statement ???

I have this code :

dim mInsurance as integer

mInsurance = 2

"select (List.Pay - mInsurance) As TPay From List"

It returns this message :
"no value given for one or more parameters"

SQL has no idea what mInsurance is - if you want to pass the value of mInsurance to SQL as part of the query use something like this;

SQLString = "SELECT (list.play - " & mInsurance & ") AS TPay FROM list"

When it's passed to SQL it will be received at the SQL end like this;

SELECT (list.play - 2) AS TPay FROM list

Thanx

You're right....