Stuck! need help

I have data for latitude and longitude for multiple counties which means I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any number, I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so no
help required there). I have tried so many different ways to do this that I
am completely lost so posting my code will do no good. Can someone provide a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000

t,

I think you are looking for...

http://allenbrowne.com/func-concat.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
"t" wrote in message
...
I have data for latitude and longitude for multiple counties which means I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any number,
I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so no
help required there). I have tried so many different ways to do this that
I
am completely lost so posting my code will do no good. Can someone provide
a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000

It doesn't sound kosher! Why don't you explain why you want to do that. You
can't do anything with the data in that kind of format. Also, a textbox
probably won't hold all your data.

Steve



"t" wrote in message
...
I have data for latitude and longitude for multiple counties which means I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any
number, I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so no
help required there). I have tried so many different ways to do this
that I
am completely lost so posting my code will do no good. Can someone
provide a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000

You might also like to take a look at the following which demonstrates two
ways of doing this sort of thing in a report, using 'across then down'
multiple columns. The report/subreport solution is far simple than the
single report solution in which the layout is manipulated in code at runtime.

Ken Sheridan
Stafford, England

t wrote:
I have data for latitude and longitude for multiple counties which means I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any number, I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so no
help required there). I have tried so many different ways to do this that I
am completely lost so posting my code will do no good. Can someone provide a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201001/1

Oops, forgot the link:

http://community.netscape.com/n/pfx/...apps&tid=24271


Ken Sheridan
Stafford, England

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201001/1

"Steve" wrote:

It doesn't sound kosher! Why don't you explain why you want to do that. You
can't do anything with the data in that kind of format. Also, a textbox
probably won't hold all your data.

Steve



"t" wrote in message
...
I have data for latitude and longitude for multiple counties which means I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any
number, I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so no
help required there). I have tried so many different ways to do this
that I
am completely lost so posting my code will do no good. Can someone
provide a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000



.
Good Question. The reason I need all this data in this format is I need to add all of the coordinates for the county to draw a map for it in google maps and open layers map. As you can imagine, doing this manually for 500 counties is going to be overwhelming and I was hoping i can at least have the coordinates ready to be copied and pasted in the map maker software to expedit things a bit. I hope this helps.

t,

Were you able to work with the code or is that not giving you what you want?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
"t" wrote in message
...


"Steve" wrote:

It doesn't sound kosher! Why don't you explain why you want to do that.
You
can't do anything with the data in that kind of format. Also, a textbox
probably won't hold all your data.

Steve



"t" wrote in message
...
I have data for latitude and longitude for multiple counties which means
I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any
number, I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so
no
help required there). I have tried so many different ways to do this
that I
am completely lost so posting my code will do no good. Can someone
provide a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000



.
Good Question. The reason I need all this data in this format is I need
to add all of the coordinates for the county to draw a map for it in
google maps and open layers map. As you can imagine, doing this manually
for 500 counties is going to be overwhelming and I was hoping i can at
least have the coordinates ready to be copied and pasted in the map maker
software to expedit things a bit. I hope this helps.

What about just creating a VBA routine to step through the records and append
all that data in that format into a text file.

I don't know enough about the map maker software, but if it allows import of
data you could probably build a file to meet the specifications for import
from the database.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Gina Whipp wrote:
t,

Were you able to work with the code or is that not giving you what you want?

"t" schrieb im Newsbeitrag
...
I have data for latitude and longitude for multiple counties which means I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any
number, I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so no
help required there). I have tried so many different ways to do this
that I
am completely lost so posting my code will do no good. Can someone
provide a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000