Google Maps a postcode link

ECEK

Registered User.
Local time
Today, 02:27
Joined
Dec 19, 2012
Messages
717
I have this formula in Excel:

=HYPERLINK("https://maps.google.com/maps?q="&A2)

Is there a way to create a query (that has the Postcode) that shows a hyperlink saying "Map" which does the same thing as the excel formula.

Im struggling with referencing the link

I've tried putting this in the Hyperlink Target on a form of an unbound field but to no success:

https://maps.google.com/maps?q="&[postcode]

Any thoughts?
 
You can create an expression that combines the "https://maps.google.com/maps?q=" string with the field in a query as I've done in the attached database. To get the hyperlink to work in the form I did what they said here.
 

Attachments

Users who are viewing this thread

Back
Top Bottom