Create a Hyperlink in a Query from text fields

  • Thread starter Thread starter Kurt Grimm via AccessMonster.com
  • Start date Start date
K

Kurt Grimm via AccessMonster.com

I would like to create a hyperlink, using just a query, by concatenating
different text values from multiple columns. I do not want to use a form,
report, or VBA coding. I can do the concatenantion, but the result set
shows as text. How do I make that a hyperlink in the result set?

Thanks...
 
Howabout you make a blank text field first. Then run your query as an
update query, filling that blank field with what you want.

Once you have it populated, you might be able to go into table design view
and change the field data type from "text" to "hyperlink."

I've never done this particular thing, but it seems like it might be an
option.
 
Back
Top