I have included an email address in a concatenated query field (the table field type for the email address is a hyperlink). I would like the email address to remain a clickable hyperlink in the query, but this is what happens:
Term >> Email:[emailaddress]
Result >> firstname.lastname@example.org
(email address is a clickable hyperlink, as desired)
Term >> NameAndEmail: [Name] & ": " & " "& [emailaddress]
Result: >> John Smith: email@example.com#mailto: firstname.lastname@example.org#
(email address gets broken into its component parts, and is no longer a hyperlink)
Does anyone know of a way to fix this ?