I apologize if this is a stupid question. I am new to SQL. I am using a select SQL statement to fill a cursor with the records. Can this totals field be calculated from within the select statement? Or do I fill the cursor with the select statement and then go back through the cursor to calculate the totals?
Or maybe there is some other solution?

Thanks in advance,

Paul
>>I am trying to create an "A/R Statement" Report. In the group header I have the customers name etc and the detail band has the individual invoices and in the group footer I have a field with a variable to sume the invoice amounts. This all works fine. I was wondering if there is any way to get this total of invoices on the group header. I want the portion that the customer sends in with the payment to have the total on it as well.
>>
>>Thanks,
>>
>>Paul
>
>You can add a totals field to your table and pre-calculate the invoice sums prior to calling the report.
>
>Mike