I want to do a select statement on a table in which besides all columns being returned, one of the columns is totaled. The idea of sending variables from vb to sql is confusing. I want to get this sum into my page to work with, and I know I use a SUM function. But declaring the variables is hanging me up. Any help, thanks. Good books or links if you know of any.