String formatting question

[t]

Hello, I don't know where the appropriate place is to ask this question but
I am hoping someone can help me in this forum. I have latitude and longitude
for county borders for over 500 counties. For each county I have anywhere
from a few hundred to thousands of coordinates, I have a need to have all the
coordinates in a(horizontal)line in this format:
Lat(space)Long,(space)Lat(space)Long, and so on....... I must stress that
Iam looking for the lat/long to be in horizontal. I guess that means no
carriage return. not sure if that is the appropriate term.
I have the list of coordinates in access. I tried to export to word and
manually do this but this will take forever. Is there a shortcut someone
could suggest?
Thanksl

 

[John W. Vinson]

Hello, I don't know where the appropriate place is to ask this question but
I am hoping someone can help me in this forum. I have latitude and longitude
for county borders for over 500 counties. For each county I have anywhere
from a few hundred to thousands of coordinates, I have a need to have all the
coordinates in a(horizontal)line in this format:
Lat(space)Long,(space)Lat(space)Long, and so on....... I must stress that
Iam looking for the lat/long to be in horizontal. I guess that means no
carriage return. not sure if that is the appropriate term.
I have the list of coordinates in access. I tried to export to word and
manually do this but this will take forever. Is there a shortcut someone
could suggest?
Thanksl

You'll need some VBA to do this. There's some code you should be able to adapt
at http://www.mvps.org/access/modules/mdl0004.htm.

 

[Tom Wickerath]

Hi "t",

Try this code from Access MVP Allen Browne:

Concatenate values from related records
http://allenbrowne.com/func-concat.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________