>Thanks for your reply but, I thing I have not explain very well.
>I have consider severals things:
>1.- The grid has infinity rows
>2.- The calculate must to be automatic
>3.- The result must to be put in a text box.
>For example....
>
>This is the grid
>--------------------------------------------------------------
>Code Description Quantity Price Total
>001 Chiken 2 5 (2*5)=10
>205 Tomatoes 1.5 2 (1.5*2)=3
>859 Bread 15 .5 (15*.5)=7
>--------------------------------------------------------------
> This is the textbox ----->>>>Total Operation (10+3+7)=20
>
>The user can put 3 items or infinity items, due to I can not use fid1+fid2+fid3
>I need somethnig like autosum from Excel "sum(since::until)"
>I hope have been very clear.
>TIA
I believe Cetin and Lal have given you your answers. As they indicated, number of rows is really irrelevant. Total can still be calculated by SQL SELECT or probably other possible methods also, then the total in the textbox updated dynamically as changes are made in the grid.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.