ms accsess and vb6

[Visual Basic]

some data entry in some field. like: ID name amount 01 taher 100 02 kamal 200 01 taher 500 I don't know what data entry in field. in my vb project i have some textbox. I want one textbox show the Id: 01 and other text box show the (total of id 01) amount: 600. like: ID amount 01 600 other textbox...