Unique Data in Access Table

[ootkhopdi]

Hi All

I Have one table which have 4 column ,i.e
ID , NAME, PAN, DOB

in this table same id having diffrent data of Name or PAN or DOB
except DOB all are text format

when i m trying to select unique id which having more than 1 name it shows 0 data, but table having these,,
how can i solve this problem..
pls help me

 

[JHB]

...
when i m trying to select unique id which having more than 1 name it shows 0 data, but table having these,,

Show you query and some sample data + which result you expect to get!

 

[ButtonMoon]

If you want the instances where the same id has two different names, try this:

SELECT id
FROM YourTable
GROUP BY id
HAVING MIN(Name)<MAX(Name);