How do I return display portion of hyperlink in union query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a hyperlink field in a table. When I run a simple query and retrieve
it, it displays just fine (e.g. "(e-mail address removed)".

When I use it in both parts of a union query on the same table, I get
multiple parts of the hyperlink
(e.g. "[email protected]#http://[email protected]#")

Is there anyway I can limit it to the "(e-mail address removed)", which I think is
the display portion of the hyperlink?
 
Use HyperlinkPart, e.g.:
SELECT HyperlinkPart(Table1.Field1, 0) AS TheAddress ...

(The constant acDisplayedValue has value 0.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UNION query hyperlink inactive. How do I make it active? 2
SUM in a UNION query 2
Data displayed wrongly in Union query 6
Union query 5
Hyperlink Part 1
Union Query 2
E-mail Merge with Attachments Source count not working 1
Can a query field display as datatype hyperlink? 1

Back
Top