Re: Spam Re: [Programmer-VB] Sort data

[skdmdn]

Mas Ronald Klo melalui coding dan outputnya diarahkan ke CR gimana caranya agar outputnya sama dengan yg di sql tadi?   ----- Original Message ----- From: Ronald Irawan To: Programmer-VB@yahoogroups.com Sent: Thursday, February 16, 2006 9:55 AM Subject: Re: Spam Re: [Programmer-VB] Sort data Bikin nya di crystal report, disana sudah ada fungsi SUM.... Salam Ronald Irawan Pt. Sanghiang Perkasa Gd. Graha Kirana Lt.5 Jl Yos Sudarso Kav.88 Jakarta "skdmdn" <[EMAIL PROTECTED]> Sent by: Programmer-VB@yahoogroups.com 16/02/2006 09:55 AM Please respond to Programmer-VB@yahoogroups.com To <Programmer-VB@yahoogroups.com> cc Subject Re: Spam Re: [Programmer-VB] Sort data Klo outputnya di arahkan ke Crystal Report bisa gak? Trus gimana perintahnya? ----- Original Message ----- From: Purwedi Kurniawan To: Programmer-VB@yahoogroups.com Sent: Thursday, February 16, 2006 9:09 AM Subject: Spam Re: [Programmer-VB] Sort data SELECT LOT, SUM(QTY) AS TOTAL FROM NAMATABLE GROUP BY LOT ORDER BY LOT On 2/16/06, Hasan <[EMAIL PROTECTED]> wrote: Pagi rekans... Saya mo tanya neh..., saya punya data gini : LOT    LOC     QTY 1       A       10 1       B       15 2       C       5 3       STAGE   50 3       D       15 3       E       35 Saya mo cari output yang gini... LOT    QTY 1       25 2       5 3       100 Saya udah coba cari di arsip tapi belum ketemu juga neh,saya cari di help nya sql 2k juga blm ktm, tolong dong kalo ada yang bisa bantu saya, gimana ya script nya??Or kalo memang ada link nya jg ga papa.... Thanx.. Hasan MM2100 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.9/261 - Release Date: 2/15/2006 Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:    http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:    [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:    Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language YAHOO! GROUPS LINKS  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to: [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.9/261 - Release Date: 2/15/2006 Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:     http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:     [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:     Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language YAHOO! GROUPS LINKS  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.