merging the values of a field in a subreport

[xoy]

hello

i am trying to prepare route cards for travels. I am preparing these
route cards in an access reports. the route points, the stops of
travel, has been provided in a routeno-stop table. I am trying to
merge the values for a particular travel. for example, the table is as
follows
route no: stops
1 museum
1 sports centre
1 tennis court
2 zoo
2 city hall
what i want is merging these values as
for 1: museum-sports centre-tennis court
for2 : zoo-city hall
is it possible and how?

i guess that this could be done through custom functions, but only that.

[MMcCarthy]

hello

i am trying to prepare route cards for travels. I am preparing these
route cards in an access reports. the route points, the stops of
travel, has been provided in a routeno-stop table. I am trying to
merge the values for a particular travel. for example, the table is as
follows
route no: stops
1 museum
1 sports centre
1 tennis court
2 zoo
2 city hall
what i want is merging these values as
for 1: museum-sports centre-tennis court
for2 : zoo-city hall
is it possible and how?

i guess that this could be done through custom functions, but only that.

You will need another field called stopno which would be as follows:

route no: stopno : stops
1 1 museum
1 2 sports centre
1 3 tennis court
2 1 zoo
2 2 city hall

TRANSFORM First([routeno-stops].stops) AS FirstOfstops
SELECT [routeno-stops].[route no]
FROM [routeno-stops]
GROUP BY [routeno-stops].[route no]
PIVOT [routeno-stops].stopno;