K
kasim
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 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?