Add to Database with loop textbox

[biggie5260]

Table
___________________________________________________________
No||Reference || Book Name ||Price ||Quantity ||Total
1 || textbox_01|| "test 01" ||"$12" ||textbox2 ||"Total01"
2 || textbox_01|| "test 02" ||"$13" ||textbox2 ||"Total02"
___________________________________________________________

1) The table above will loop until the record ends. What is needed is how to add the Textbox above (which have same name) in each row into 1 table in DB(MS Access).

2) Another thing is that we need the overall total of the column "Total" which is different in each row/record.

Is there any chance that the above task can be completed? I am new to ASP coding and mostly i used GUI in Adobe Dreamweaver to add record into database. Since there is a loop function for the table above, i am quite blur and out of idea to do this. IS there any expert who can help me?

Thanks,

Regards,
Biggie

 

[lebisol]

1. look into "ASP update record" being how you said "loop" I would imagine you need to look for "ASP update multiple records"

2. do this in access using a query vs. thorough a page

http://www.techonthenet.com/sql/sum.php