Recent content by 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...

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],"#"))

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.