[belajar-access] Menghitung total harga per pelanggan

Dear pakar access, mohon bantuannya...bagaimana cara membuat total harga seluruh material per pelanggan di report, misal :
Report yang ingin ditampilkan

IDPelanggan Nama Alamat NmMaterial Jumlah Harga Total
1A Joko Rantau Kabel NYG 10 10000 100000
CM Cubikle 2 54000 108000
Dan lain2
Total Biaya Material 208000
2A Ali Rantau Kabel NYAG 5 10000 50000
IM Cubikle 3 50000 150000
Dan lain2
Total Biaya Material 200000
3A Budi Rantau Kabel NYAG 15 10000 150000
DM Cubikle 1 60000 60000
Dan lain2
Total Biaya Material 210000

Dimana field tabel yaitu : IDPelanggan, Nama, alamat, Nmmaterial, jumlah,harga, total dan TotalBiayaMaterial
Bagaimana perumusan di report,apakah harus pembuatan di query terlebih dahulu ?mohon petunjuknya..

------------------------------------

SPAM IS PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/