Hello, I am kind of new at access and need some help. let me set this up for you so you know what iam trying to do. I have 100 excel files. Each one has a link like y://test/test1/abc and each file is linked by a number so for example..

405 y://test/test1/abc
406 y://test/test1/def

ect...

numbers in one collum and link it other collumn. Now in the report i would like for it to show the excel file using the link I have. Right now the report just shows the link :(

Thansk for any help!
glen