Filter tracks by year & genre - Advanced search

[Osric]

Hi
I am trying to filter my tracks by genre and year. In the example shown I am getting expected results but wanted to also find (add) tracks with the genre rnb for the same period 2000-2009. Do I have to run this as two seperate queries or is there a way to run this as one filter/find expression. Every permutation I have tried hasnt worked including add as a 'group' (i'm not exactly sure how that works).

PS. I also need to exclude any genres that include Soulful (e.g. soulful house) hence that condition.

Any help/guidance is much appreciated.
Cheers
Osric

[radio42]

Is this what you want?
Note, that you can also use the 'Text' view to simply add logical brackets (which defines a group).

In this example, the 'Genre' can contain either 'soul' OR 'rnb'; plus (and) the 'Year' must be between 2000 and 2009; and the 'Genre' should not contain 'soulful'...
Text:

Code: Select all

(Contains([Genre], 'soul') Or Contains([Genre], 'rnb')) And [Year] Between('2000', '2009') And Not Contains([Genre], 'Soulful')

[Osric]

Yes! Thank you so much. I wasn't sure how to get the most from the advanced search so will use the example you provided to try and learn more.