Data Type Problem in query 1

[baybook]

I'm having a brain freeze. This query is not working and I know I'm using the wrong format

dim somenumber

queryreg = "select * from Quote where quote_id ="&somenumber&""

Can someone tell me what I am not seeing as I've tried several variations.

Thanks!!!!

 

[Lothario]

Try this:

queryreg = "select * from Quote where quote_id ="&somenumber

-L

 

[Lothario]

if somenumber is just a number then the above query should work...but if it also contains some characters then try...

queryreg = "select * from Quote where quote_id ='"&somenumber&"' "

-L