view duplicate only

[iraidotel@yahoo.com]

Dear All,

I still used access 2003, and i have a problem with my job. If i have a table (left figure) with the duplicate data, and i want to use access to filter those duplicate data (right figure).
What method in access to process that case?can i use the query tools or another method?

ragard,Ira

 

[arnelgp]

just a simple query will do:

select hole_id, deviation from tabel where count(hole_id)>1;

 

[iraidotel@yahoo.com]

I've tried to use select hole_id, deviation from tabel where count(hole_id)>1; , but not work

thank you,
ira

 

[arnelgp]

try this my friend: