Access Table to Google Map URL String

[esidb]

I have a query, which makes a table. From the table (name: CustomerContracts), I am looking to pull the fields named; addr1,city,state,zip and pass them on to a google URL. There are typically multiple records in the string- and I would like it (for example) to create a URL like this:

http://maps.google.com/maps?saddr=a...r=address,+city+st+zip,+to:addr,+city+st+zip,

,+to:addr,+city+st+zip, ,+to:addr,+city+st+zip, ...

Can someone please tell me how I would go about this?

I am hoping to do it through a button "view maps

 

[Markothy]

Hey, have you been able to accomplish this?