I have a page that checks the inventory of our products. BUT, I also have a seperate table that has customers on waiting lists for our products. What I'm trying to do, is when it loops through items that are less than 1 in stock, to also show me (if any) the total people that are on the waiting list for that item.<BR><BR>If I query it with a # that I put in, it works fine. BUT, If I try to query it using the DetailID from teh recordset it's looping through, it won't work. It says there is a data mis-match. I've converted it to a Integer using the CInt(Expression) and it still doesn't work. Maybe I'm just using the improper format? <BR><BR>I've tried (this is to the point code so you can get an idea of what I'm doing):<BR>[code language="language"]<BR>varHowMany = CInt(rsCheck.Fields.Item("ProductDetailID").Value) <BR><BR>Set rsGetWaitingList = Server.CreateObject("ADODB.Recordset")<BR>rsGetWai tingList.ActiveConnection = MM_xxx_STRING<BR>rsGetWaitingList.Source = "SELECT DetailID FROM QRYWaitingList WHERE DetailID = "+varHowMany""<BR>[code]<BR><BR>I just know I'm missing some kind of basic thing where this is not working. Any ideas?