are you really sure you want to offer this choice to users?

please explain why someone would be interested in a car that is between 15000 and 25000 (range 1) or greater than 45000 (range 4) but not between 25000 and 45000

that doesn’t make sense

i think you should allow a choice of only one price range

Hi r937.
You have a good point. I could limit the price choice to only 1 range at a time.
Maybe selecting range 1 and 4 is really silly (it’s just another way of saying any price at all), but range 1 and 2, 2 and 3 make as much sense as only range 1 or only range 4, for example.

However, just to answer the question as a learning exercise.

But what if the user selects price range 1 and 4 or 2 and 3?

If they want 1 and 4, it means it should be valid if the range is within 1 or 4.

1 OR 4
(1) OR (4)
(TblVersoes.Euros >= 15000 AND TblVersoes.Euros < 25000) OR (TblVersoes.Euros >= 45000)

See what I did there?

(Just to note, the last set of parentheses isn’t really necessary, it’s just there for clarity.)

Also, note that if it was filtered so they were AND-ed together (which you could technically do), they would never return a result, as no number can be >= 45000 and less than 25000.