Mau ambil data dari table mesin absent, contoh datanya mentahnya seperti :
Absensi by Employee Id Query
UserID
EventDateTime
INOUT
Dutyon
Dutyoff
EventKey
0000000000000062
12/3/2007 7:43:39 PM
0
07:43:39 PM
16843011
0000000000000062
12/3/2007 9:14:29 AM
1
09:14:29 AM
16843010
0000000000000062
12/3/2007 9:55:40 AM
1
09:55:40 AM
16843010
0000000000000062
12/3/2007 2:14:16 PM
0
02:14:16 PM
16843010
0000000000000062
12/3/2007 4:04:43 PM
0
04:04:43 PM
16843010
0000000000000062
12/3/2007 6:16:14 PM
0
06:16:14 PM
16843010
0000000000000062
12/3/2007 7:16:25 PM
0
07:16:25 PM
16843010
0000000000000062
12/3/2007 8:48:37 AM
1
08:48:37 AM
16843011
0000000000000062
12/4/2007 8:40:40 PM
0
08:40:40 PM
16843011
0000000000000062
12/4/2007 6:05:56 PM
0
06:05:56 PM
16843010
0000000000000062
12/4/2007 3:44:21 PM
0
03:44:21 PM
16843010
0000000000000062
12/4/2007 3:00:53 PM
0
03:00:53 PM
16843010
0000000000000062
12/4/2007 1:26:43 PM
0
01:26:43 PM
402718977
0000000000000062
12/4/2007 10:29:53 AM
1
10:29:53 AM
16843010
0000000000000062
12/4/2007 11:36:20 AM
1
11:36:20 AM
16843010
0000000000000062
12/5/2007 7:49:13 PM
0
07:49:13 PM
16843010
0000000000000062
12/5/2007 3:05:13 PM
0
03:05:13 PM
16843010
0000000000000062
12/5/2007 10:29:33 AM
1
10:29:33 AM
16843011
0000000000000062
12/5/2007 11:16:37 AM
1
11:16:37 AM
16843010
0000000000000062
12/5/2007 12:37:24 PM
0
12:37:24 PM
16843010
Mau di filter dengan for.next or otherwise lah, dengan hasil menjadi masuk
lebih awal absent dengan pulang yg jam yg paling akhir absent
0000000000000062
12/3/2007 7:43:39 PM
0
07:43:39 PM
16843011
0000000000000062
12/3/2007 8:48:37 AM
1
08:48:37 AM
16843011
0000000000000062
12/4/2007 8:40:40 PM
0
08:40:40 PM
16843011
0000000000000062
12/4/2007 11:36:20 AM
1
11:36:20 AM
16843010
0000000000000062
12/5/2007 7:49:13 PM
0
07:49:13 PM
16843010
0000000000000062
12/5/2007 9:08:38 PM
0
09:08:38 PM
16843011
Bagaimana dengan scriptnya gitu per id per tanggal, jam masuk awal dan jam
pulang terakhir, dengan mas-mas milis master minta tolong.
Salam
irwan
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Newbie Semarang
Sent: Friday, April 04, 2008 10:01 AM
To: [email protected]
Subject: Re: [indoprog-vb] For ....next
Maksudnya sedalam apa ?, terus data apa, dari mana dan seperti apa contohnya
?
Kalau data dari tabel (database), khan bisa pake DO WHILE - LOOP atau WHILE
- WEND
dengan mendeteksi 'status' EOF-nya...
Salam,
Newbie
2008/4/2 Irwan <[EMAIL PROTECTED] <mailto:musyirwan%40gmail.com> com>:
> Hi Miliser,
>
> Mau Tanya ada yg punya sample "for ..next " yg agak dalam.(untuk ambil
> data)
>
> Salam
>
> irwan
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
