tks a lot it worked fine now .:-)

tks for the query its working but it missed the

TrackBooks

202B

204C

pls help us?

i will make clear,

I am looking for items that have more than one occurrence in track, in the above sample track 204 has 3 distinct Multiples and the track 202...

I no need the distinct , I need same tracks which have multiple books and I don't need tracks which have

unique books for(eg)

Track | Books

-----------------

204 | A

204 |...