Grand Total

Hello,
I have field amount i want a grand total of amount
field in textbox with the help of sql query and should
update too
Thank you

try this statemet

sql = "select sum(total) from <table> where code='<value>'"