Check box multiple entrys showing

[trackmedic]

I have a query which combines data from two tabes (main tabe and sub table) In the main table I have a field named "boat" in the sub table, I have a check box showing if the boat did a drill for a quarter of a year.

If my boat named alice did a drill for the first three quarters, I want the query to show "alice" and the three corosponding check boxes on one line.

what I am getting instead is a query with three entries showing multiple entries

"alice" check for qtr one
"alice" check for qtr two
"alice" check for qtr three

how can I get them on one line?

Thanks in advance!