I am stumped on this, I am querying an Access database to select a name based on a dollar amount on a requisition form. I multiply a qty field in my form by a unitprice field in my form (both are "input type = text") to get a variable I call intTotalPO. I've tried to use CCur(intTotalPO) to convert it to the field type in my Access DB which is Currency. Each time I run submit the query I get an error ' 80040e10' that says [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. If I change my field type in Access to "Text" and set the parameter in my Select statement to read ('" & IntTotalPO & "') it works fine.<BR><BR>How can I convert my variable to one Access understands to be currency or even number (I settle for that)!!<BR><BR>Please Help!!!