BAQ with Subquery

If you have 3 matches, you will get 3 lines.

If you want them on one line, there are ways to do that. To concatenate whatever shows up, you can use this method. It’s kind of a pain to set up, but works nicely.

If you will always have the same records, you can make 2 subqueries, and limit them so you only get one per subquery back, then you can have 3 columns.

What is it that you want it to look like in the end?