I IanT Registered User. Local time Today, 22:54 Joined Nov 30, 2001 Messages 191 Mar 22, 2005 #1 Hi I am running a sql statement which looks at dblProdID as a value, am I missing something as sql is not working! "WHERE tblProduct.ProductIDNumber = & dblProdID & "
Hi I am running a sql statement which looks at dblProdID as a value, am I missing something as sql is not working! "WHERE tblProduct.ProductIDNumber = & dblProdID & "
FoFa Registered User. Local time Today, 16:54 Joined Jan 29, 2003 Messages 3,653 Mar 22, 2005 #2 "WHERE tblProduct.ProductIDNumber =" & dblProdID Your reference is inside the quotes, so it thinks it is a string instead.
"WHERE tblProduct.ProductIDNumber =" & dblProdID Your reference is inside the quotes, so it thinks it is a string instead.
