
Using Numbers in SQL Text
Question: Here is the code I am using to do a query from an Access 97 database: Query = “SELECT * FROM DiamondList WHERE (ProductNumber = ‘” & tempProduct & “‘)” ProductNumber is the name of an Access 97 database field with the data type set to number. When I