>>Hello Naomy
>>
>>Your Question is :
>>Do you want to calculate totals for the whole grid or put totals in an extra column of the grid?
>>
>>i want to calculate , no on any column in my Grid but on a textbox in my form the value of the column , for example : €totalinvoice , where the grid column checkbox is true.
>>
>>for example
>>Columns on my grid : Check , nº invoice , totalinvoice
>>
>>check nº invoice totalinvoice
>>.T. 11111 1000,00
>>.T. 22222 500,00
>>.F. 3333 100,00
>>
>>my textbox total on my form outside the grid is equal to : (1000,00+500,00)=1500
>>
>>Thanks, i hope you understand better now.
>>
>>Luis Santos
>
>Sure, it's much better now.
>
>select MyTable
>sum TotalInvoice to lnTotal for Check = .t.
>thisform.txtTotal.value = m.lnTotal
I really hate this:
... for Check = .t.
There is no need for one additional comparison, why not just:
... for Check
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.