Terima kasih atas responnya.
Pertanyaannya gini aja; gimana supaya data tersebut bisa di grouping. Group
by Nama Apotik, yg di-SUM qty dan value. Dgn catatan alamat dan kota tetep
muncul dan formatnya tetep di query. Bukan report.
(kalau di report sudah bisa. Cuman ya itu. saat export ke xcell dia gak mau.
Padahal aku perlu data tsb di xcell agar bisa diedit lebih jauh).
On 20/09/06, xaviero <[EMAIL PROTECTED]> wrote:
>
> mangnya formula nya mau apa ? output mau seperti apa ?? sudah memasukkan
>
> formula apa ?
> kurang lengkap infonya neh...
>
>
> maman durahman wrote:
>
> > dh,
> >
> > Mau tanya, nich. Udah nyoba-nyoba tap 'kepentok' mulu.
> >
> > misal kita punya tabel ginih;
> >
> > nama apotik | alamat | kota | qty.sls | value sls |.
> >
> > Nah..aku mau bikin query dimana di query tsb | nama apoti | di grouping.
> > Artinya apotik yg sama jadi satu field aja. Qty dan val otomatis
> dijaddin
> > satu dgn fungsi sum. Masing-masing apotik nantinya masih tetep punya
> kolom
> > |alamat| dan |kota|
> >
>
--
Wasalam,
Durahman
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/mailplus/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/mailplus/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
