Change hyperlink names with another field name

[AccessKerry]

I am trying to work out how to update hyperlink fileds with the name of the client located in another column. I want it so my reports display the name as a hyperlink which users can press on and go directly to the clients online form.

 

[arnelgp]

you need to parse it:

=[ClientNameField] & Mid([HyperlinkField], Instr([HyperlinkField], "#"))

you must format the new field/textbox as hyperlink

 

[AccessKerry]

Thank you for the reply, where would I put this? I have tried in a query and getting '#func!' in the result.
Link: [Last Name] & Mid([Get Page URL],InStr([Get Page URL],"#"))

 

[AccessKerry]

OK, I have managed to link the excel sheet in which I created a new table off where I formatted the link field as a hyperlink, this works but shows the full link.

I tried to run a query off this with a new column that shows Clickable Name: [Full Name] & Mid([Link Trimed],InStr([Link Trimed],"#")) and I am getting the result as Dow, Jane#http://0#. Having this go into another table that has this field formatted as a hyperlink doesnt' work