ADO query

The scenario is :- I use a table in sql server for customer records in which columns are like - common thing which are included in a clothing bill..quantity,price,total amount.

I need to multiply these colums with certain amount of quantity which a customer takes..like if he purchases two pants of 600Rs,and a shirt of 800,it shud be calulated and given to the total Amount table..from which it is to be printed..

Now,I hope you understand my deluge..Plz Help.

Please can you forward code for it or a part of it atleast?or atleast give an idea about the approach for it?please it's like on my throat now..Hope you understand that..