Dear Mas Hning, Pertama, buat text box di form footer, misal "txtSumHarga", dengan control source =Sum([Harga]). Lihat gambar berikut:
Kemudian, control source "Total" set menjadi =[QPENJUALAN Subform].[Form]![txtSumHarga],sesuai gambar berikut:
Hasilnya setelah di run adalah sesuai gambar berikut:
Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
Sofyan Efendi
----- Original Message -----
From: <aukahlap@yahoo.com>
Sent: Wednesday, January 09, 2013 6:46 PM
Subject: [belajar-access] menghitung total [1 Attachment]
>
>
> salam kenal para pakar...
> saya pemula yang baru belajar ms-access mohon petunjuknya.
> dalam file terlampir berikut, bagaimana cara menghitung kolom total? apakah penempatannya sudah betul?
> program ini hanya sekedar mencatat penjualan saja, tidak memerlukan tabel master barang/harga dsb.
> mohon bantuan pencerahan & mohon maaf sebelumnya jika sudah pernah dipertanyakan.
> salam
>
> hning swara
>
> <*>Attachment(s) from aukahlap@yahoo.com:
>
>
> <*> 1 of 1 File(s) http://groups.yahoo.com/group/belajar-access/attachments/folder/1088486629/item/list
> <*> Prj1.mdb
>
> ------------------------------------
>
> 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/
>
__._,_.___
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
SPAM IS PROHIBITED
.
__,_._,___
No comments:
Post a Comment