Hyperlink to a Docmunet

[BigZZ]

Hi all. I have a small problem.

I have a query that combines few different tables in order to create a View (Query) that is then used to by and Excel sheet to update a list. The Excel is dynamical updated when new data is inputted in the Access Tables.

But one of the fields in a query is combination of path name and report name (another filed in one of the tables) that crate a complete path to a file that contains some additional information.

Now since the Excel is updated dynamical and users of this Excel sheet are not very advanced. I waned to make it easy for them to just click on the location of the file and the filed opens up. But I am not able to make the Query filed that contains the file destination hyper liked.

Does anybody have any idea how this cloud be done.

Thanks.

P.S. using Access 2007

 

[Uncle Gizmo]

you want to export a u n c from access into excel and when it is in excel you want it to be a live hyperlink?

 

[BigZZ]

I guess that would work.

Ultimately I just want to do it once and everything i updated dynamically without me haveing to do any additional work once the data is in the excel. Just click Refresh button!.

Thanks.