Coba2 bantu Mas Piet..
Kasus :
Cari isi field Nama yang jumlahnya > 1
Asumsi :
Field = Nama, Table = Karyawan
Query :
SELECT Nama, Count(Nama) as TotalNama
FROM Karyawan
GROUP BY Nama
HAVING Count(Nama) > 1
Cheers
Devis :)
-----Original Message-----
From: ITCENTER@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Pieter
Sent: Thursday, August 04, 2005 8:49 AM
To: ITCENTER@yahoogroups.com
Subject: [ITCENTER] Cari duplicate data di dalam satu field [Access 2000]
Dear IT'ers semua,
Maaf kalo sudah pernah ditanyakan sebelumnya.
Mungkin rekan2 ada yg tau bagaimana caranya mencari data yg duplicate
didalam satu field?
Kalo mo nyari satu persatu kayanya kebanyakan recordnya > 30000.
Mungkin dengan query?? [maklum gak terlalu ngerti masalah database] Program
pake Access 2000.
TIA
Regards,
Pieter
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung,
Keluar, Mode Kirim : [EMAIL PROTECTED]
::: Hapus bagian yang tidak perlu (footer, dst) saat reply! :::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$
Iklan/promosi : www.itcenter.or.id/sponsorship $$
Yahoo! Groups Links
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
::: Hapus bagian yang tidak perlu (footer, dst) saat reply! :::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> 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/
