Creating a hyperlink with a Query

[TomPose]

I have a database with a field that is set up as a hyperlink. That works fine. Now I want to extract part of that field using a query that strips off the filename, leaving only the directory. The field I created in the query is called goto.
goto: (Left([path],(Len([path])-1-Len([filename]))) & "#&quot

The name of the directory comes out right in the query, but how do I turn it into a hyperlink so I can click on it and jump to my directory??

Thanks,
Tom

 

[psemianonymous]

I don't think this is possible in Query view. Put the query in a continuous form and use that to run your hyperlinking. Access doesn't have a great number of features built-in for the query/datasheet view.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm