Data structure is not normalized and causes difficulty.

Access throws in a lot of unnecessary parens and that can make it hard to read. Use of .Value is not needed. Simplified via SQLView window:

SELECT * FROM Concerts WHERE ConcertDate BETWEEN [start date] AND [end date] AND ([B2] LIKE "*" & [Singer name] & "*" OR [B/B1] LIKE [Singer name] OR etc);

Really should not use punctuation/special characters in object naming.