coba bantu yah....
str = "SELECT field_batch, count(field_batch) as Jumlah " & _
"FROM T_Field " & _
"GROUP BY field_batch " & _
"ORDER BY field_batch"
set rs = new adodb.recordset
rs.open str, cn
itu untuk querynya
untuk menampilkan dalam listview (misalnya) dengan catatan untuk index yang nol dikosongkan aja (klo saya)
while not rs.eof
listview1.ListItems.add,, rs!field_batch
listview1.(ListItems.Count).SubItems(1)=rs!field_batch
listview1.(ListItems.Count).SubItems(1)=rs!Jumlah
rs.movenext
wend
ok met mencoba ya... semoga sukses :)
regards,
-Petry-
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.
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
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.
