Totals: calculating

Results 1 to 2 of 2

Thread: Totals: calculating

  1. #1
    John C Guest

    Default Totals: calculating

    I&#039m working with an Oracle database and want to sum the columns of information I pull back. I&#039m using a loop to bring back all the records that meet my SQL criteria and want to place a total at the bottom of these columns. <BR><BR>Any ideas? Thanks!

  2. #2
    Coolboy Guest

    Default RE: Totals: calculating

    Depending on the data type and recordset, you want to do something like this:<BR><BR>sum = 0<BR>while not rs.eof<BR> sum = sum + cint(rs("FieldName"))<BR>wend<BR><BR>then just put the sum where you want it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •