saya kurang tahu soal pemakaian NZ tapi kalau sintax ISNULL di access cara pakenya agak beda SELECT * FROM Member WHERE IsNull(Nama) ==> (kalau nggak salah)
Kalau SubQuery di access juga bisa kok, mungkin Anda salah nama field atau table. Coba analisa kesalahan dari pesan errornya. terima kasih. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-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/
