Bro, salam kenal.
Tinggal tambahin group aja, kaya gini..
* xM = "Select Distinct ID, TglIn From Tabel Where
> ID='" & .Fields("ID") & "'"
* Group by id, tglin
_____
From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf Of Gege Nugroho
Sent: Tuesday, February 26, 2008 11:42 AM
To: [email protected]
Subject: [Programmer-VB] Tanggapan: Masalah pada SELECT DISTINCT up. bung
Erwan
Trims bro dah meluangkan waktu njawab....
But, it;s won't work...
Datanya malah ngga masuk sama sekali.
Bingung dah....
Erwam Suaj <[EMAIL PROTECTED]> wrote:
Pakenya Select Top 1 ID, TglIn, JamIn
>From Tabel Where ID='" & .Fields("ID") & "'"
--- Gege Nugroho <gegenugroho@ <mailto:gegenugroho%40yahoo.com> yahoo.com>
wrote:
> Guys...
> Gwe punya masalah lage (yang kesekian kalinya
> :-)....)
>
> Kondisi Gwe gini:
> Pake Visual Basic 6.0 SP 6.0 ActiveX
> Database MySQL 5.0
> Tanpa komponent ADODC
>
> Saat nyimpen gwe punya data :
> ID TglIn JamIn
> 01 2008-02-20 15:00:00
> 01 2008-02-20 15:01:59
>
> Nah gwe mau data itu yang kesimpen cuman satu ajah
> (yang mana ajah) dengan statement ini, malah masuk
> dua-duanya : xM = "Select Distinct ID, TglIn, JamIn
> From Tabel Where ID='" & .Fields("ID") & "'"
>
> Kalo gwe pake ini, data ngga masuk sama sekali :
> xM = "Select Distinct ID, TglIn From Tabel Where
> ID='" & .Fields("ID") & "'"
>
> Juga kalo pake ini, ngga masuk juga : xM = "Select
> Distinct ID From Tabel Where ID='" & .Fields("ID") &
> "'"
>
> Jadi intinya bagaimana menggunakan statement
> SELECT DISTINCT ini dimana hanya menyortir satu data
> ID dan TGLIN ajah.
>
> Ato ada statement lain yah?
> Trims yo...
>
> PS : Sori kalo tatabahasa gwe rada njelimet...
> hehehe
>
> dariyangbingungngambilsatudata
>
>
> Regards
> Gege Nugroho
.
<http://geo.yahoo.com/serv?s=97359714/grpId=8332265/grpspId=1705115364/msgId
=28685/stime=1203999279/nc1=3848576/nc2=4990222/nc3=4836044>
Regards
Gege Nugroho
_____
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
<http://us.rd.yahoo.com/evt=51733/*http:/mobile.yahoo.com/;_ylt=Ahu06i62sR8H
DtDypao8Wcj9tAcJ%20> it now.
