Maybe someone can help me with this, or has something similar.

I have many cd's and sometimes I can have 40-50 cd's of a single performer.
Some of these cd's are compilations/best of, and sometimes I already have these musics in another cd. If all the musics in one compilation are repeated in my collection I could easily discard this compilation (one cd less, one free slot in the shelf ...)

I would like to have a query going like this: for Album X, find all repeated instances of each title.
Report would go like this:
Album X
Title 1 ocurrences: Album X, Album 1004, Album 1014
Title 2 ocurrences: Album X
Title 3 ocurrences: Album X, Album 3056, Album 54
...
(bad luck here, because title 2 is not repeated anywhere ...)

Too complicated ? Impossible due to Catraxx structure ? This is what is called "nested search" in SQL, but I don't know if Catraxx implements this.

Many thanks

This is not possible in CATrax, but it might be possible to define such a query in MS Access.

Fredrik, would you kindly exemplify ? Many thanks.

Sorry, I don't have a query example.