Prev: How can I activate the Access07 ribbon?
Next: Calculations in Group Footer
From: t on 25 Jan 2010 17:58
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

From: Gina Whipp on 25 Jan 2010 18:06
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" <t(a)discussions.microsoft.com> wrote in message
news:CB988899-3509-4FD8-8BEF-E9056FE3F1CF(a)microsoft.com...
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


From: Steve on 25 Jan 2010 19:00
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
santus(a)penn.com


"t" <t(a)discussions.microsoft.com> wrote in message
news:CB988899-3509-4FD8-8BEF-E9056FE3F1CF(a)microsoft.com...
>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
>


From: KenSheridan via AccessMonster.com on 25 Jan 2010 19:46
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/Forums.aspx/access-gettingstarted/201001/1

From: KenSheridan via AccessMonster.com on 25 Jan 2010 19:48
Oops, forgot the link:

http://community.netscape.com/n/pfx/forum.aspx?tsn=1&nav=libraryMessages&webtag=ws-msdevapps&tid=24271


Ken Sheridan
Stafford, England

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201001/1

 |  Next  |  Last
Pages: 1 2
Prev: How can I activate the Access07 ribbon?
Next: Calculations in Group Footer