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?
=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?