Prev: "Too many fields defined" issue
Next: Access Help
From: t on 16 Jan 2010 16:06
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
From: John W. Vinson on 16 Jan 2010 16:47
On Sat, 16 Jan 2010 13:06:01 -0800, t <t(a)discussions.microsoft.com> wrote:

>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.
--

John W. Vinson [MVP]
From: Tom Wickerath AOS168b AT comcast DOT on 16 Jan 2010 17:17
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/
__________________________________________

"t" wrote:

> 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
 | 
Pages: 1
Prev: "Too many fields defined" issue
Next: Access Help