We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
cn.Open strConnectionString strSQL = "SELECT * FROM dbo.ReceiptInfo WHERE Job = '54' ORDER BY CustomerID" Set rstReceivingInfo = CreateObject("ADODB.Recordset") 'Open the recordset object executing the SQL statement and return records rstReceivingInfo.Open strSQL,cn 'determine whether there are any records If rstReceivingInfo.EOF Then msgbox "Recordset is empty. Check your SQL string." Exit Function Else [b]dim TotalNetWt ' this is the variable I'm having trouble with[/b] 'if there are records then loop through them Do While NOT rstReceivingInfo.EOF ' this is where I'm trying to force the user of a numeric variable so I can add values [b]TotalNetWt = CDbl(TotalNetWt) + rstReceivingInfo("NetWt")[/b] rstReceivingInfo.MoveNext Loop End If rstReceivingInfo.Close set rstReceivingInfo = nothing cn.close set cn = nothing ...
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|T-SQL: Stored Procedure Syntax||3||33|
|SQL Get Store Procedure Column Name As Row||5||41|
|SQL 2014 missing dll from Bin?||3||33|
|MS Access Pasthru Query to Execute SQL Stored procedure||8||39|