....and pay_date = '" & ctgl & "%' Nah di sini masalahnya...kalo mau pake '%', maka operatornya bukan '=', tapi 'LIKE'
------------------------------------- ....and pay_date LIKE '" & ctgl & "%' ------------------------------------- Best Regards, - yudis - --- In [email protected], "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 > > 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] 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/
