Modifying a Hyperlink field in a table using a query

  • Thread starter Thread starter Amit
  • Start date Start date
A

Amit

Windows XP, Access 2K
======================
Hi,

I have a table with a field "OrgURL" of the type HyperLink.
The URLs entered in the field are missing the "http://"
before it. I'd like to prefix the data in the field with
the string "http://".

I tried to do this using a query:
newURL: "http://" & [tblOrganization].[OrgURL]

It kinda worked, but the resulting new field has all the
URLs twice, like this:
http://www.yummydesigns.com#http://www.yummydesigns.com#

I'm not sure how to correct this, so that the resulting
URL is in the format: "http://www.yummydesigns.com"
(without the quotes).

Thanks for any help.

-Amit
 

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

Hyperlinks in a query (Access 2003) 1
Hyperlink Part 1
MS Access: Creating hyperlink field in a query 0
Can a query field display as datatype hyperlink? 1
Convert Query field display from text to hyperlink 3
Split data in field on character return 0
making hyperlink in query 1
Make table query: [Enter 1] AS Test 1

Back
Top