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 ?
1
Reply
AdChoices