Question
Report question/problem
I am trying to produce a report.
One query returns three rows, which is correct, because there are three line items. I then link those three records to another table to get a description.
The problem I am having is that this record has two descriptions, so instead of returing just the three records, it returns six records, three for the first description and three for the second.
How can the query or report just produce the three records, and have both descriptons on the same line/column separated by a comma, if this is even possible ?
One query returns three rows, which is correct, because there are three line items. I then link those three records to another table to get a description.
The problem I am having is that this record has two descriptions, so instead of returing just the three records, it returns six records, three for the first description and three for the second.
How can the query or report just produce the three records, and have both descriptons on the same line/column separated by a comma, if this is even possible ?
AdChoices