query can help me in an sql query that I'm running in access, as the image shows, the idea is to leave only one line with the fields that are visible. In the image there are 2 numbers of cpbnum and the idea is to summarize them as they appear in the result image. thanks
