All,

I previously asked about getting the sum of a columnin a db. I figured out to add an item to SELECT statement to create a variable:

txtSQL.CommandText = "SELECT customer_number, past_due_30, SUM(total_due) AS 'intTotalDue'" & _
                     "FROM accounts_receivable" & _
                     "WHERE past_due_30 > '0'" & _
                     "ORDER BY past_due_30 DESC ;"

But this appears to create a variable named intTotalDue that is the total of the entire column (total_due) from the database, not just the total of the column (total_due) in the recordset.. How do I total just the filtered record's column? Do I have to create a nested SELECT statement or can I use the HAVING clause - if so how?

thanks a lot,
Nick

A recordset is made up of columns. That means you can't get a single value for the whole recordset, it will return that value for each row of the recordset.

Use an output parameter to a stored procedure.
http://www.aspalliance.com/stevesmit...les/sprocs.asp

regards
David Cameron

Only those records that match your criteria (WHERE past_due_30 > '0') should be summed. SUM() should only sum those records matching the criteria, not all the records in the table.

Cheers
Ken

www.adOpenStatic.com