Thanks for the question. Using the repeater field, it will not be possible to query the data as you have asked.
However, it is possible to do so using a plugin called
posts 2 posts. This will replace the repeater field on the clients CPT and allow you to connect the client to work.
Then you can use normal WP_Query to get the posts. The
posts 2 posts plugin contains new parameters for the WP_Query so you can ask for posts that are connected to works and then also add in the work tax_query.
It will be a bit tricky, but it will be possible.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!