J
Jen
Hi~
I'm trying to create a report, and having some trouble. I have a
table with fields of the following:
Number
Description
Value
and in my report, I would like to have the records with the same
number to be grouped. I
I have it working so that it shows the number once and a total, but
then it shows a line for each description. That is a text field, so
the only option for totals is to count the number. I would like to
concatenate those fields and separate with a comma.
Right now I get:
Number Total
Description 1
Description 2
Description 3
Number2 Total2
Description 1
Description 2
Description 3
Number Description 1, Description 2, Description 3 Total
Number2 Description 1, Description 2, Description 3 Total2
Thanks in advance for your help!!
I'm trying to create a report, and having some trouble. I have a
table with fields of the following:
Number
Description
Value
and in my report, I would like to have the records with the same
number to be grouped. I
I have it working so that it shows the number once and a total, but
then it shows a line for each description. That is a text field, so
the only option for totals is to count the number. I would like to
concatenate those fields and separate with a comma.
Right now I get:
Number Total
Description 1
Description 2
Description 3
Number2 Total2
Description 1
Description 2
Description 3
Number Description 1, Description 2, Description 3 Total
Number2 Description 1, Description 2, Description 3 Total2
Thanks in advance for your help!!