Display data base on query criteria

[xdenama]

I have query base on one table. I want to hide / display row in query base on year (2014). If any Club don't have year 2014, will be hide (in this case, Yellow Club will be hide) other wise any Club have year 2014 will be display (Red and Blue) with all years (2014,2013,2012) in query. Please help me.

I attach the file for reference. TQVM.

 

[sneuberg]

I sounds like you want are trying to establish some sort of criteria for the select query. I suggest you watch this video on queries.