create hyperlink using infor from other fields

[socalsurv]

:banghead:I have a table with field address and field city I want to create a hyperllink in another field the form being http -- mapsdotgoogledotcomslashmaps?q=5750+division+st,+riverside,+ca (I had to change to string so it doesn't convert to a hyperlink I don't have ten posts) so i need to add a string "http-maps.google.com / maps?q="string from address with spaces replaced by +"+"string from city field" any suggestions seems it should be simple but I am unfamiliar with access thanks in advance

 

[Steve C]

Have I got this right?

the first part of a URL is stored in one place and is always the same.

the second part of the same URL is stored somewhere else.

you want to link the two parts into one Hyperlink?

 

[socalsurv]

The 1st part is always the same the second part is in another field but i need to replace spaces with + sign the final part is in a second field i want to put the new string into a third field that will be a hyperlink

 

[socalsurv]

The field that I create will be an intermediate step then from the link created I will copy a hyperlink and extract a lat and long from it that I will use for proximity searches if that helps any. Thanks again.

 

[socalsurv]

joining the strings isn't the problem I can do that pretty easily with vb but I don't know how to access the fields or place the string in the new field

 

[Steve C]

Do you want to split the Field2 into all it's pieces either side of a space bar, then reassemble them with a + sign intead of a space?

I'm thinking ParseWord() Function.

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