Combining two records as one record in report

[DevAccess]

Hi

I have below report rows in table and I would like to show them as one record

Name --> Product Id --> Sub ID --> Product Invoice Number
D1 --> 3209 ----> 21--> AE5
D1 --> 3209 ----> 21 --> AE6


Can I show this as below

D1 --> 3209 --> 21 --> AE5, AE6

since Invoice Number is only different here so I want to combine them as one record.

Please assist.

 

[Ranman256]

make a 'pick list' table. you can use a list box to dbl-click items to add them to the pick list.
join this pick list to the data table.
All items in the pick list are now combined in the report.

 

[sneuberg]

I think you will have to do this in the record source query of the report. You may see that if the Product Invoice Numbers were numbers that you wanted to add that you would do this with an aggregate query grouped by Name, Product ID and Sub Id and with the sum of the Product Invoice Number. But you don't want that. You want to concatenate them separated by commas. The query designer doesn't have anything built in to do that in an aggregate query but you can specify an expression for the total. I believe if you install the Allen Browne's ConcatRelated function in a module that you could adapt that to your problem. The attached database has the Allen Browne function in a modules and contains a query that demonstrates how this could be done.