>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

Paul:

Try select , sum(invoice) as inv_total ....