coba cara ini :
where ..... pay_date >= '" & Format(ctgl,"yyyy-mm-dd 00:00:00") & "' and
pay_date <= '" & format(ctgl,"yyyy-mm-dd 23:59:59") & "'"
selamat mencoba
regards
armadya
Kyan <[EMAIL PROTECTED]> wrote:
asumsi ctgl = 2006-03-08
from payment as p, invoice as i
Where p.apar_id = i.apar_id and p.exportsts = 0 and pay_date = '" & ctgl & "%'
group by p.apar_id, i.period
order by p.apar_id, i.period
Dalam data payment terdapat data sbb:
40000001 2 100 1 2005-12-16 00:00:00 51000.00 1 1240008597 2 100 1 2006-03-08
00:00:00 42185.00 0 NULL40009390 2 100 1 2006-03-08 00:00:00 42185.00 0 NULL
Dengan query diatas ternyata data yg tampil adalah ketiganya, padahal saya
hanya inginkan data yg tampil hanya yang pay_date = 2006-03-08 saja. Bagaimana
query yg seharusnya jika saya hanya ingin tampilkan data dengan paydate
=2006-03-08 saja.
Terimakasih
Zazz
[Non-text portions of this message have been removed]
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
SPONSORED LINKS
Computer internet security Computer internet business Computer
internet access Computer internet privacy securities Computer internet
help Computer internet connection
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "indoprog-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.
---------------------------------
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
[Non-text portions of this message have been removed]
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-vb/
<*> 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/
