Combining field entries on the output screen

I have a report which queries a trip table. Each trip is linked to one or more destination recrods in a separate table.

The output for the report repeats the trip number for each destination, i.e.

Trip Number Destination
123 Germany
123 Italy
125 Canada
126 Spain
126 Portugal
126 Egypt

I’d like the output to look like:

Trip Number Destination
123 Germany,Italy
125 Canada
126 Spain,Portugal,Egypt

But the following would be OK if I could prevent the tool from putting blocking the output based on the trip number:

Trip Number Destination
123 Germany
Italy
125 Canada
126 Spain
Portugal
Egypt

Any help or advice anyone can offer would be appreciated.


Ron Schiller (BOB member since 2004-07-22)

How about “Insert Break” on your trip no.?


jobjoris :netherlands: (BOB member since 2004-06-30)